Thanks for the question, really good one.

yea, well, as we do typo when typing... this was completely clicko. (when I saw red, I was like "WHA......T"?... then I saw it...

Thank you, Steve, good one.

(Well, it took less then 30 seconds for me to read and select the right choice- either my mind did malfunctioned or I just became smarter...hmm...

That's the whole point. (its not about- performance analysis, gain; just a piece of code written long...

Luis Cazares (5/4/2016)

No need for cursors, or several statements.

WITH CTE AS(

select distinct personid from @t

)

SELECT PersonID,

...

Like I said... very old code... as-in sql 2000... (to me, one of the fine block of code 16 years...

(EP)Z!!!

No need of STUFF. (very old code)

declare @t table (PersonID int, AreaCode varchar(10), Exchange varchar(10), Root

varchar(10))

declare @t1 table (PersonID int, phone varchar(2048))

declare @pn varchar(2048), @Pid int

insert @t

select 10001, '555', '555',...

Even though knowing the answer what it could be... that missing...

all I can think of- what other options would have been there....

and also, this is the good time to mention the forgotten/missing validation on "insufficient choice of answers" while actual...

This is one of the link I still have in my bookmarks - http://sqlmag.com/t-sql/coalesce-vs-isnull. (Lots of variations to test)

Thanks for the reply, Hugo, that cleared my doubt.

From the answer section, it says - "Restore the differential backup from Friday night at 8pm".

I have one doubt - do we have to install the diff-backup of just Friday's...

Oh good... I am not alone.

I still...

With quick analysis on the field names, selected the right ones. (now just wondering- say if I have checked "all of the above", now what other two check boxes I...

THAT statement, my friend, puts entire mankind back with hope. We never know what we...

Thank you, @ArnoKwetters. That link is great. 🙂