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.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair
How to post code problemsHow to post performance problemsForum FAQs