Jeff Moden (3/12/2011)
I absolutely agree but, just like I said a year and a half ago, too many people simply give up too easily on finding a high performance set based solution. :-P
Aleluya! I waited a year and a half for your reply and I was certain it will come sooner or later :-D By the way, I do agree.
You waited for the wrong thing then because I said exactly the same thing that year and a half ago. ;-)
Jeff Moden (10/10/2009)
Also,I read here that,we should avoid cursor as much as possible.
This is not correct. Is like saying you should avoid surgery as much as possible - why if surgery is your most effective alternative?
Actually, that is not entirely correct... Heh... I find that too many people go for "elective surgery" instead of finding the better way.
You should indeed avoid cursors "as much as possible". I'll agree that it's sometimes not possible but most folks simply give up too early.
is pronounced ree-bar and is a Modenism for R
First step towards the paradigm shift of writing Set Based code: Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
Although they tell us that they want it real bad, our primary goal is to ensure that we dont actually give it to them that way.
Although change is inevitable, change for the better is usually not.
Just because you can do something in PowerShell, doesnt mean you should. Helpful Links:
How to post code problemsHow to post performance problemsForum FAQs