It will certainly work. Execute the query - this will generate a...

Here you go:

SELECT DISTINCT 'SET IDENTITY_INSERT '

...

These are temporary tables. Single and Double hash defines the scope of these tables. Refer the link below where it tempory tables are very nicely explained.

http://www.simple-talk.com/sql/t-sql-programming/temporary-tables-in-sql-server/

Here is the query to get the list of all "User" tables have identity column:

SELECT DISTINCT Object_name(t.object_id)

FROM sys.all_columns c

INNER JOIN sys.tables...

Thanks Ron for this great question today as well. It required a little bit of reading before attempting it.

Happy that I got it correct in the end 🙂

L' Eomot Inversé (10/6/2012)

---

But all those settings up front are just a red herring - completely irrelevant to the question. It's not a trick question, because it's extremely unlikely...

L' Eomot Inversé (10/6/2012)

---

It's a question with a correct answer, no scope for argument for that (as I have come to expect from Ron's questions, which seem to be always...

Please post the correct solution and which query worked for you. This might help us.

I might be wrong as well. Let jdelorino confirm!

Jason-299789 (10/5/2012)

---

Lokesh Vij (10/5/2012)

---

Here is the modified version with totalcount values:

SELECT ERRORCODE, ERRORDESC,

Terminal_1 = MAX(CASE WHEN TERMINALID = 'Terminal_1' THEN TOTALCOUNT ELSE 0 END),

Terminal_2 = MAX(CASE WHEN TERMINALID =...

Here is the modified version with totalcount values:

SELECT ERRORCODE, ERRORDESC,

Terminal_1 = MAX(CASE WHEN TERMINALID = 'Terminal_1' THEN TOTALCOUNT ELSE 0 END),

Terminal_2 = MAX(CASE WHEN TERMINALID = 'Terminal_2' THEN TOTALCOUNT...

mccork (10/4/2012)

---

Lokesh Vij (10/4/2012)

---

sam.dahl (10/4/2012)

---

I recognised the attempt to insert null and hence picked 2,0 because that's what the two select statements return: 2 and 0. It's the insert statement...

You are welcome Abhilash 🙂

+1

I also...

I don't think there should be a problem. Here is the sample code which executed perfectly

CREATE TABLE dftBIT

(

id INT,

...