And if the query returns a million rows, then what?

So... did that work for you or what?

Lookup sp_ExecuteSql in BOL... it will do as you ask.

Matt... shouldn't that be 0-9?

Lemme guess... it's an aggregate view and the WHERE clause you're using contains one of the aggregated columns...

Simon_Lo (4/29/2008)

---

when google used a black verison for the one day it did state that it actually made no difference to energy consumption and was to more highlight people awareness...

Um, where will be be getting @Value_List from? A GUI? If so, you've just opened yourself up to a nasty little case of SQL Injection.

Lemme know... there are...

Most of this is straight forward... the comma separated list you want to make can be done by using the technique in the following...

http://www.sqlservercentral.com/articles/Test+Data/61572/

Try using backslash n instead of backslash r. Some text files only have a "linefeed" or "newline" character instead of an actual carriage return.

Not if the dupes encompass the key for the group by like this one does...

Heh... don't get too excited... it apparently includes 2 decimal places 😛

What is the maximum number of ServiceID's you can have per ClientID?

Darned "smiley" faces... lemme try again...

--===== If the temp table already exists, drop it

IF OBJECT_ID('TempDB..#Steps') IS NOT NULL

...

Ok... just sharing... a million row median calculation can be fast... very fast... here's a chunk of code I posted about 3 years ago... it's demo code so you'll need...

Ok... I know I'll get a lot of flack...