SELECT *
INTO Temp3
from
( SELECT B.Name
FROM [Temp2] as B
WHERE B.Name
Not IN (
SELECT E.WorkerName
FROM WorkerDetail as E ) )
Why does this produce an error?
-
Complete Sentences and Good Formating always Help :)Tyler Carter– Tyler Carter2009-07-18 03:50:17 +00:00Commented Jul 18, 2009 at 3:50
-
You will have to post all the table creation scripts too.Scott Whitlock– Scott Whitlock2009-07-18 03:53:51 +00:00Commented Jul 18, 2009 at 3:53
-
Hello, jame, are you there? Did you just ask the question and run away?John Saunders– John Saunders2009-07-18 03:59:36 +00:00Commented Jul 18, 2009 at 3:59
-
my given query does not work ......why?I want to insert value in temp3jame– jame2009-07-18 03:59:51 +00:00Commented Jul 18, 2009 at 3:59
-
jame, please edit your question and show us the error you see.John Saunders– John Saunders2009-07-18 04:04:31 +00:00Commented Jul 18, 2009 at 4:04
|
Show 6 more comments
2 Answers
If you want to use a derived table you need to alias it:
SELECT T1.*
INTO Temp3
from
( SELECT B.Name
FROM [Temp2] as B
WHERE B.Name
Not IN (
SELECT E.WorkerName
FROM WorkerDetail as E ) ) AS T1
I'm not sure if you actually need to use a derived table, however.
This should also work:
SELECT B.Name
INTO Temp3
FROM [Temp2] as B
WHERE B.Name
Not IN (
SELECT E.WorkerName
FROM WorkerDetail as E )
Comments
Maybe Temp3 already exists? In MSSQL SELECT..INTO used to populate new table with data. If this table exist, you can use INSERT INTO .. SELECT FROM statement.
