nice question.

got to know something new today... thanks 🙂

yep, i too use this query to remove duplicates...

was wondering, which query is faster, this one or the one mentioned in the article...

scottm30 (7/26/2010)

---

Nice article, thanks for sharing.

The...

good one... thanks 🙂

agree completely, we use computed columns for getting the full name from firstname, lastname combination...

wware (7/21/2010)

---

forjonathanwilson (7/21/2010)

---

A calculated field is not going to be A+B, because thats just a stupid...

Your script is just ultimate! thanks a ton 😀

thanks, this explains everything...:-)

i have populated data till year 2050 as a contigency measure 😀

Tom Williams-175034 (7/15/2010)

---

Here we've always been of the belief that you shouldn't have tables with date ranges, because tables...

i m getting the foll. error:

Warning: Null value is eliminated by an aggregate or other SET operation.

my stored proc is calling a scalar valued function.

thanks, nice simple one... 🙂

thanks , really nice question...:-)

thanks; was about to ask if there was any specific reason to mention SQL 2008...

kevin.l.williams (7/13/2010)

---

Thanks for the question. I learned something. I didn't know that Not ending Transact-SQL...

thnx nice one 🙂

SELECT REPLACE('Hello world',NULL, 'zzz' );

as suggested by you... even this returns the same output

SSMS question after a long time..:-) thanks

thanks Duncan 🙂

I also had the same issue... was getting the count 20 but didn't know why... its because of the compatibility level set to 80..

these rollback type questions are my favourites...

thanks 🙂