139 reputation
3
bio website
location United Kingdom
age
visits member for 1 year, 11 months
seen Sep 26 at 15:34

Sep
1
comment What do cursors do internally?
@AaronBertrand example using while loop instead of recursive cte here sqlfiddle.com/#!6/c5fd8/12/0
Sep
1
comment What do cursors do internally?
@AaronBertrand I will try and come up with an example, but I'm thinking of a while loop used instead of a recursive CTE. I should state that I believe that you should try to avoid both cursors and while loops.
Aug
29
comment What do cursors do internally?
A while loop is not always exactly the same as a cursor. A cursor always accesses one row at a time whereas a sql statement within a while loop can potentially still be set based, for instance all rows where level=1 then all rows where level=2 etc.
Aug
5
comment Selecting from an excel spreadsheet into SQL Server table
you appear to be writing to #mytemptable then you try to select from ##mytemptable. I guess you want ##mytemptable in both places
Nov
16
awarded  Supporter
Oct
30
awarded  Revival
Oct
30
awarded  Teacher
Oct
30
answered Slow Performance Inserting Few Rows Into Huge Table