Viewing 15 posts - 50,881 through 50,895 (of 59,078 total)
And if the query returns a million rows, then what?
April 29, 2008 at 10:06 pm
So... did that work for you or what?
April 29, 2008 at 9:51 pm
Lookup sp_ExecuteSql in BOL... it will do as you ask.
April 29, 2008 at 9:42 pm
Matt... shouldn't that be 0-9?
April 29, 2008 at 9:29 pm
Lemme guess... it's an aggregate view and the WHERE clause you're using contains one of the aggregated columns...
April 29, 2008 at 9:27 pm
Simon_Lo (4/29/2008)
April 29, 2008 at 9:25 pm
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...
April 29, 2008 at 9:11 pm
Most of this is straight forward... the comma separated list you want to make can be done by using the technique in the following...
April 29, 2008 at 8:54 pm
Try using backslash n instead of backslash r. Some text files only have a "linefeed" or "newline" character instead of an actual carriage return.
April 29, 2008 at 8:47 pm
Not if the dupes encompass the key for the group by like this one does...
April 29, 2008 at 8:44 pm
Heh... don't get too excited... it apparently includes 2 decimal places 😛
April 29, 2008 at 8:42 pm
What is the maximum number of ServiceID's you can have per ClientID?
April 29, 2008 at 8:34 pm
Darned "smiley" faces... lemme try again...
--===== If the temp table already exists, drop it
IF OBJECT_ID('TempDB..#Steps') IS NOT NULL
...
April 29, 2008 at 8:29 pm
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...
April 29, 2008 at 8:27 pm
As a result, we need to be sure we work closely with them to get proper validation built into all applications.
Ok... I know I'll get a lot of flack...
April 29, 2008 at 8:08 pm
Viewing 15 posts - 50,881 through 50,895 (of 59,078 total)