Got it right after a lot thinking, cause I looked the question wrongly. I saw 1000, 8060 and 65365 all of a sudden I took the data type in to...

Thanks for the good question. 🙂

wish to see more like this.

(I guess this depends on the initial type of the data which in the first position.

For this "select '130'+'120'+1" it...

SomewhereSomehow (8/7/2012)

---

Be sure on what server and db do you execute "select ... into" query. Also specify schema like "select ... into dbo.MyTable...".

After that, when you want to query created...

😀

P1: Wanna DATE?

P2: Which format?

Hello; nice question indeed.:-)

The below code which I have copied/written from the QotD email which I received today and this gives me the result as "1,error error, error" due to...

R.P.Rozema (3/8/2012)

---

Actually no. The code was intentionally presented as a picture for 2...

Nice.

(from next time rather converting to image, it will be better to paste the exact SQL)

Nils Gustav Stråbø (3/6/2012)

---

Hugo Kornelis (3/6/2012)

---

So this view properly implements row-level security, allowing a "normal" user to...

thats the whole point.

not sure why this is an issue? as a end user can't go and query the MSDB on the table you have mentioned.

And such task are mainly...

mine mine mine the one is mine. 🙂

sknox (3/1/2012)

---

If you set ANSI_NULLS off, your code will be incompatible with current standards...

Awesome 🙂

Woooohooooo 1 is mine today. 🙂

SELECT ID, Name FROM

(

SELECT 1 AS ID, 'Active' AS name

UNION ALL

SELECT 2, 'Active'

UNION ALL

SELECT 3, 'InActive'

UNION ALL

SELECT 4, NULL

UNION ALL

SELECT 5, 'Idle'

UNION...

It gives me this error on the 2nd block

Msg 8117, Level 16, State 1, Line 3

Operand data type char is invalid for multiply operator.

I guess E stands for ERROR?

(sorry for cheating) but I really don't get it 🙁

(by the way the question is really cool, i know remember one requirement which I had on the similar thing where...