Dird (4/23/2013)
Evil Kraig F (4/22/2013)
There's no cursor in his solution.Is there any documentation/book which proves this? Oracle would be running implicit cursors here; I have a hard time believing sql server doesn't since so much of this rdbms is "coincidentally" similar
I'm unable to test now (at work) but I'll run a similar kind of operation on a large table later & query sys.dm_exec_cursors
Dird
Oracle uses cursors (its version of a cursor) for all queries.
Do you have any evidence whatsoever that SQL uses cursors for this type of code?
SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.