posts - 10, comments - 49, trackbacks - 0

SQL Server Madness

Fast T-SQL Row Number Generator

You can expect: This is a medium intensity post (you should not get a migraine, but I make no promises). I Expect (that you have the following experience): T-SQL Stored Proc experience Windowed Function experience Basic Join understanding Row Number Generation There are a number of ways to generate row numbers in T-SQL.  One way is to create a temp table with an identity column and do inserts into that table.  Typically you do it in a while loop with a counter.  I've used this method in the past and it...

posted @ Thursday, May 29, 2008 11:16 AM | Feedback (9) | Filed Under [ SQL Server Madness ]

Powered by:
Powered By Subtext Powered By ASP.NET