Mark,

I would definitely use a correlated subquery for this:

SELECT *

FROM #queue q

WHERE Success = 0

AND Batch =

(SELECT MAX(Batch)

FROM #queue q1

WHERE...

Dave,

What constitutes a failure?

Are you thinking of an MSDN subscription? I believe there are some packages available for ISVs for around $700, if you sign a contract stating that you're going to...

If the explanation had been, "you should pay attention to formatting," this would have been a great question.

However, this was obviously the result of a total accident by someone who...

Good catch Yuvraj... I was too quick on the copy and paste, I'm afraid!

Rajiv,

What error did you get?

Are you certain? You said you were getting NULL errors...

Anyway:

UPDATE YourTable

SET YourColumn = NULL

WHERE YourColumn = ''

Scott,

For that purpose I usually do something along the lines of:

UPDATE Tbl

SET x = 'y'

WHERE x = 'abc'

IF @@ROWCOUNT = 0

INSERT Tbl (x) VALUES ('y')

... but in this...

Can you post DDL and sample data to reproduce the problem?

http://www.aspfaq.com/etiquette.asp?id=5006

Joe,

I'm pretty sure that none of the Perfect Shuffle algorithms had a DBMS in mind! Do you really believe that a cursor is better than the ORDER BY NEWID()...

Have you tried updating statistics on both databases?

Run sp_updatestats and see if that fixes the issue.

Maybe you can explain what's wrong with the code? Are you getting an error? Is it doing the wrong thing? It's difficult to tell just by eyeballing...

What does "empty" mean? It sounds as though your columns are already NULL. Replacing that with another NULL probably won't help you too much.

Have you looked into using...

SELECT MIN(CASE Description WHEN 'Tiering' THEN Value ELSE NULL END) AS Tiering,

SELECT MIN(CASE Description WHEN 'Strategic Overview' THEN Value ELSE NULL END) AS StrategicOverview,

SELECT MIN(CASE Description WHEN 'Tier Pricing Report'...

Hari,

How can a result set possibly contain only distinct user_ids, yet contain multiple rows for each ID which has more than one row? Can you show some example output?