new things for me...

thanks

i tried by disabling the constraint on table roles master but after doing that also it didnt worked

truncate is not working..

Gives error-

Cannot truncate table 'rolemaster' because it is being referenced by a FOREIGN KEY constraint.

worst question...

I run this query on sql 2005 and 2008 both ant 3.4

if ppl posted question based on server dependent thn they should mentioned the version...

I lose the points for...

very easy one...

i dont think this question worth 2 points

good explanation Hugo 🙂

thanks Artoo for the links... 🙂

But the query that you pasted is just simply give the first non null value as the coalesce does and give output as 'NULLFail'.... 😛 (no tricks in it)

today's QOD...

thanks for the explanation from all you guys..

good start of the day with +1..

first did R&D about coalesce thn attempt the question and select correct answer 🙂

I am a newbie in DBA so can you plz explain me about this set based equivalent approach to cursor..

I dont have any idea about this

i have one more scenario similar to this...

I want to update city id in ziptable but as a city can contain different zip codes so I dont know how to...

hey Chris,

can you plz tell me why you placed this line -

INNER JOIN (select fstate from WCDentalSQL_TOR..ZipCode GROUP BY fstate) d ON d.fstate = Z.fState

I am not clear with the...

previously I fetching statecode rows from zipcode tables which contains about 45k rows due to that also cursor was taking too much time so i replaced with state table and...

thanks Chris it works fast now