neat and clear ..

Thanks for the question .

+1

nice question

thanks for the question

just pass any variable ..it works . in the MERGE T-SQL statement.

and yes what merge statement ??

Lokesh Vij (10/3/2012)

---

One more way to achieve the result:

SELECT c.Cnum,c.D1,c.D2,c.D3,c.D4

FROM #cnums c JOIN #dnums d

ON c.D1 = d.D OR c.D2 = d.D OR c.D4...

nice question ...

thanks.

cool ..

start with reading this one ; it starts with the basics and may be something more

http://msdn.microsoft.com/en-us/library/aa174541(v=sql.80).aspx

....

go to the stairways to indexes in SSC ; that's a wonderful...

I got it wrong; why do have to in such a hurry !!;-)

thanks for the question ..

what query ?

If it's syntax error inside procedure ; then stored procedure would never have complied.

can you please elaborate , with DDL ??

nice question ..

I remember someone asked me this question , I was quite confused and my guess was the default ..

apparently when I tested I did work..

thanks for the question..

an easy one for wednesday ..

thanks...

nice and easy ...

I must say i like the permutation ..I had to search the answer within multiple options ..

Thanks for the question !!

I actually had to read to get this one correct ..

thanks for the question ...

Thanks Naseer ; Nice question ..

philip.cullingworth (9/18/2012)

---

Raghu,

The results you are getting are due to you only specifying the collation on the where clause.

The query is selecting rows 1, 3 and 6 since they are the...