|
|
|
January 2003 March 2003 April 2003 May 2003 June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 April 2008 August 2008 |
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Job taking more than 1 min Posted by Venkata Srinivasa Rao at 12/28/2003 10:56:04 PM Dear all
I have one DTS for order downloading from web to unix. the dts runs for every 5 min. In the dts it creates 4 files. after 2 min of the scheduled time one cron runs at unix server and it takes the output files. the dts should not take more than 1 min to run. But daily atleast 2/3 times its...more >>
Making sure all records match Posted by peg at 12/28/2003 10:24:20 PM I have 2 tables:
Product_PerformanceConds
(ProdID Int
FieldValue Int)
Vendor_Capabilities
(VendorID Int
FieldValue Int)
I need to come up with a sql querry that brings back the vendors that match
ALL of the fieldValues for the Product
So for example ProdID 4 might have 4 PerfCon...more >>
Error Message for No Records Posted by Scott at 12/28/2003 7:49:39 PM In the below statement, if I supply an invalid date range, QA returns the
"50002" Error Message from the "IF" section. I'm trying to also return a
different error "50003" if the recordset is empty, but my "ELSE IF" section
isn't catching it. I simplified the SQL statements for clarity, but I want...more >>
Fill Factor Posted by Tom at 12/28/2003 7:12:31 PM I am confused as to what fill factor, as a percentage, is
suppose to mean. I have two conflicting references in BOL
as to what is meant by fill factor (see below). There are
others as well, but I don't feel like flipping a coin and
picking one when it could be doing the exact opposite as I
...more >>
What is wrong with this SP Posted by dave at 12/28/2003 6:42:10 PM statNo in Null everytime???
CREATE PROCEDURE CheckQuoteSaleStatus
(
@selectedContactID int,
@statNo int OUTPUT
)
AS
DECLARE @salesCount int
DECLARE @quoteCount int
SELECT
salesCount = COUNT(CONTACT_ID)
FROM tempSales
WHERE (CONTACT_ID = @selectedContactID) AND (SalesAct...more >>
osql returning error Posted by Jibey Jacob at 12/28/2003 6:21:10 PM Hello
When I issue the command:
osql -E -S (local)\NetSDK -i InstNwnd.sql
I'm getting the following error:
[DBMSLPCN]SQL Server does not exist or access denied.
[DBMSLPCN]ConnectionOpen (Connect()).
I can see SQL Server is running, there is an icon in my System Tray and the service is up and...more >>
Provisionally Disable Check Constraint Posted by noor at 12/28/2003 4:03:29 PM Hi, All
I want to disable a check constraint for a command and after run it , enable
constraint in SQL Server 2000.
Disable Constraint
Run My Command
Enable Constraint
Regards
Abbas
...more >>
Query Analyser question, any tips on this? Posted by mbwalmsley NO[at]SPAM hotmail.com at 12/28/2003 3:02:41 PM Often I change a Select statement from returning all (*) columns to
only a (select) few. To do this I need to know the names of the cols.
To do this I expand User Tables..Table..Columns, then type the names
by hand.
This seems like such a waste of time.
Do know any shortcuts to copy to t...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
BULK INSERT bug with large files? Posted by Sam Elmore at 12/28/2003 1:34:32 PM I am using BULK INSERT to import a large web log file into
a SQL Server 2000 SP3a table. I have set the
rowterminator to '\n' and the fieldterminator to ' '. The
web log file has been converted to ASCII and has had all #
comment lines removed. The log file is about 430MB. When
I run th...more >>
Count By Domain Posted by Wayne Wengert at 12/28/2003 6:06:44 AM I have a field which contains email addresses in the usual form
(myaccount@domain.com). We'd like to get a count of entries by domain. The
result we want would be something like:
267 hotmail.com
199 msn.com
178 aol.com
etc.
I have not figured out a good way to accomplish this. Can an...more >>
How can i get this to work? Posted by peg at 12/28/2003 5:00:48 AM I have a Products table that has various fields to show detail of the
product such as Material, Configuration, etc.. There are about 12 different
detail records.
All of the various possible field choices for each are in another table
type, ValueID (ident col), value
Material, 15, Plastic
Ma...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |