Subscribe to this blog
New York City .NET
The author of the NYCdotNet blog is a VB.NET and SQL server developer living and working in New York City. The author seeks to promote clean, readable, efficient code in both VB and SQL from design to development, deployment, and application maintenance.
Archives: February 2011
Renumbering Rows in a Table Variable (or Table/Temp Table)
I was recently working on a data cleanup problem where I had to do lots of comparisons of one row to the next row and I was trying to do my best to avoid using cursor for this. I was using the old trick of having an IDENTITY() field and… Read more
4 comments, 1,050 reads
Posted in New York City .NET on 18 February 2011