Are you using an SP or View? Is it comparing columns (i.e. Column A= Column B)? Are they both INT datatype? Find out what column that value appears in and...

I agree with the above postings. Change:

SET @dStart = '03/03/2003 07:00 AM'

SET @dEnd = '03/03/2003 07:00 PM'

To:

SET @dStart=DATEADD(hh,-2,'03/03/2003 07:00 AM')

SET @dEnd=DATEADD(hh,-2,'03/03/2003 07:00 AM')

and change your WHERE...

I believe that has been corrected in SQL Server 2005. Another case where a more timely release of smaller upgrades would have been preferred over waiting years for a major...

One way I've gotten around it that works sometimes is to create a dummy flat file in the output directory and use that to map the fields and transformations. It...

I am  not sure how the state could force management or anyone else for that matter to join a union. Union membership is covered by the NLRA (National Labor Relations Act). If you...

I've worked in both union and non-union shops. The union shop is the only job from which I was ever terminated. Even though I was management, and the state law...

That worked great! Thanks.

They're trying to find out how people feel about our cafeterias. To simplify:

Q1: Do you use the cafeteria?

If Q1 is Yes then Q2: Are you satisfied or dissatisfied?

If satisfied then...

Thanks. I've had that "Select *"="Bad" beaten into me for so long...

Select * ? Wouldn't this be even more efficient?

DELETE FROM PARTY_COMMENT WHERE exists

(SELECT PARTY_ID FROM PARTY WHERE PARTY.CORRESPONDENCE_ID = @corrid and

PARTY.PARTY_ID = PARTY_COMMENT.PARTY_ID

)

DELETE FROM PHONE WHERE exists

(SELECT PARTY_ID FROM PARTY WHERE...

Jorge,

I thought about EXISTS, but figured IN was just as good. I suppose I could set up a test to see if they come up with the same execution plan...

Microsoft SQL Server  2000 - 8.00.818 (Intel X86)   May 31 2003 16:08:15   Copyright (c) 1988-2003 Microsoft Corporation  Enterprise Edition on Windows NT 5.2 (Build 3790: )

Well, my SA's tell me we're on SP3a. Then again, they're not the brightest bulbs in the bunch.

Besides, Noeld, this is from the cursor to dynamic SQL conversion thread you...

We're at SP3 and we get an error if we pass a varchar to EXEC() that's over 4000 in actual length.

I ran into this problem recently. I believe EXEC (@sql) is expecting an NVARCHAR string. Since NVARCHAR takes 2 bytes for every 1 byte of a VARCHAR string the max...