Hi,

I think some people might be missing the point of this article. The author has just suggested a very graceful alternative to using a cursor when bulding some set of...

Cannot agree more, nice and handy.

I just wanted to say that it is neater to use EXEC in front of the stored procedure rather than GO at the end,...

Don't quite agree with Simon's point on JLSSH's suggestion. No data is lost there and the query is far better in terms of performance!

How about just turning Identity_Insert on for the column in question? In that case it will behave just like ordinary int, with additional benefit of having default value of identity?

Hi!

Fiund this on Microsoft site - certainly does address issues, unfortunately does not provide much towards the solutions

http://www.microsoft.com/technet/community/chats/trans/sql/sql0326.mspx

Hope it will be of...