Good and easy question. Helped to have some thoughts about CTE and stated some points.

** CTE is a 'reference' to the source tables. i.e. Any changes to CTE will affect...

I LOVE TRICKY QUESTIONS ALWAYS... THANKS SAMITH..

[Code="sql"]

declare @Nations table(Name varchar(20))

insert into @Nations Values

('Sri Lanka'),('Sree Lanka'),('Sri Lanka'),('Sri Langa'),('Sree Langa')

select * from @Nations

select...

Very Interesting question.. Thanks Ron.. Helped to walk through SOUNDEX and DIFFERENCE..

Nice question. Helped me to refresh ' WITH TIES'.. Thanks

Good straight and easy question.. Thanks..

Simple and interesting one. Got it right.. Thanks....

@evgeny Garaev. Nice attempt. Congrats. Today is yours.

Thanks Steve for the new year gift. And Happy new year for entire "sqlservercenter" family..

Saramilla.. Author oru paavamanu.. leave it.. Avanu vendi njan maapu chodikunnu.

Thanks for Good question..

"Eid Mubarak" to all my SQL Friends.. 🙂

Very very Good Question... :p

Got 1 out of 6 is correct ;(

Good Morning Sreeni.. Thanx for the easy Point..

Nice question Sreepathi, Thanx for the easy point 🙂

Good Question. Tricky as well..