I'm sorry... my bad... not enough coffee. I thought you wanted to know what the "N" was (as most frequetly do) and didn't read the rest of the WHERE...

My appologies... I missed the fact that this is for display purposes...

You don't need a TempTable nor any form of dynamic SQL for this in SQL 2005... this will do...

Sorry for not getting back to this sooner... Barry went in the same direction that I would have. (Thanks for the honorable mention in the code, Barry :))

Karthick, look around...

Heh... sorry Gus, I took it the wrong way... thought for sure it was directed at me and didn't understand why especially since you know me pretty well... thank you...

Good explanations, Gus.

Mahesh Bote (4/23/2008)

---

[font="Verdana"]

Thanks Jeff for updating me. I was under impression...

John Mitchell (4/23/2008)

---

You can avoid the "speed at all cost" methodology if you want... but I'd suggest that you haven't and you won't. Considering all that you've written about...

Wanna tell me what's really going on? This code has errors in it in the form of variables that were never declared. That means this code doesn't take...

Heh... that's a mess, huh? And now, you understand why properly documented code and properly named columns/tables are so valuable. 😛

I'll take a look, Karthick...

vyas (4/21/2008)

---

Use the conversion functions, CAST and CONVERT, to convert expressions of one data type to another data type when these conversions are not performed automatically by Microsoft® SQL Server™...

It's because you likely did not make a "firehose" (FAST FORWARD) cursor. The real key is, what did you write and why aren't you using set based instead of...

COUNT()

GROUP BY

You can just put the data in a table with the IDENTITY in forward order and the select in reverse order. Or, you could select using ROW_NUMBER OVER(ORDER BY).

Mahesh Bote (4/22/2008)

---

[font="Verdana"]

Jeremy (4/22/2008)

---

If I'm not mistaken, #temp table are implicitly dropped at the end of the stored procedure regardless of whether or not you explicitly drop it. ##temp tables...

Thanks... I'll use Gus', then. I'll also throw in the dog/cat thing.

Just in some preliminary testing on 4Meg rows, I've found that the SET STATISTICS TIME ON command really...