Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
3
Newest
 Supporter
Impact
~9k people reached

  • 0 posts edited
  • 0 helpful flags
  • 1 vote cast
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