Something like this? I suspect you don't need aggregates. If you do, why MAX() of a long character field? This solution assumes (updateID,langID) is unique in updatedetails.

select

--Had a look at the functions from http://aspfaq.com/show.asp?id=2390 linked in the above post,

--and made some minor alterations, using a fairly arbitrary set of conditions.

--These versions should...

Using dynamic SQL doesn't generate a new spid (session). It generates a new batch. Temp tables have session scope so they are visible to the new batch. Table variables have batch...

Your problem most probably arises from the presence of NULLs in your employees table:

Q1:

i ValidReps_Original_Query...

To expand on the above comments, v9 supports nested comments. But v8 recognises */ and not /* inside a comment block. Once a /* is encountered, further /* s are ignored (treated as comment text)...

The answer is the difference between the single-quote character:

'

as a part of a string value, as for example ,

lastname

--------

O'Toole

 

(which is part...

Yes, no dangling transactions please. Remiss not to mention it. And yes, once again, (all together now) must you use a cursor?

I (embarassingly!) dropped the GROUP BY clause when pasting the code in. Still, at least it wouldn't parse at all, as is.

group

by b

The reason given was:

>The reason for relying on a "Set @Qry" then executing it, is because this is only a small part of a larger SP and there...

@@rowcount is another example. If you want to capture both @@rowcount and @@error, you have to get both at the same time, directly after the statement you are 'watching', otherwise the...

--If you only want to return one row you can use:

top 1 *

...

You may need to add some null handling in the having clause.

The question is, how to pass this back to the client while the cursor is processing.

To expand on the idea of processing batches, you can open the cursor first, then...

You could do the process in batches keeping track of how many batches of what size have been executed so far. If you have more than one connection to the DB, the process...

Good decision. First rule of cost-benefit analysis: the past doesn't exist.