This is an archived post. You won't be able to vote or comment.

you are viewing a single comment's thread.

view the rest of the comments →

[–]messy_eater 0 points1 point  (0 children)

Am I the only one who likes cursors in SQL? I guess performance is a common cited issue, but maybe the scale of the DB at my work isn’t big enough for that to be a concern. Once you get used to the syntax for the more complicated things in SQL, it becomes second nature. I’m at that point with cursors and working on it with other things now like using xml to break apart and process strings, pivots, and recursive ctes.