Select..INTO - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Select..INTO

Author

Topic

pravin14u
Posting Yak Master

246 Posts

Posted - 2006-08-18 : 05:42:01

I am tryin the following query

select NULL,NULL,[sub prod grp] into tmp_SubProdGrp
from rep3 where [sub prod grp] not in(select distinct SubProdGrpOld from Stage_SubProdGrp)

Error message:Server: Msg 8155, Level 16, State 1, Line 3
No column was specified for column 1 of 'tmp_SubProdGrp'.
Server: Msg 8155, Level 16, State 1, Line 3
No column was specified for column 2 of 'tmp_SubProdGrp'.

How can i insert only a single coloumn(in multi coloumn table) using INTO?

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-08-18 : 05:44:44

select NULL AS COL1, NULL AS COL2, [sub prod grp] into tmp_SubProdGrp
from rep3 where [sub prod grp] not in (select distinct SubProdGrpOld from Stage_SubProdGrp)

Peter Larsson
Helsingborg, Sweden

pravin14u
Posting Yak Master

246 Posts

Posted - 2006-08-18 : 05:55:05

It worked..Thanks

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-08-18 : 05:56:55

quote:
Error message:Server: Msg 8155, Level 16, State 1, Line 3
No column [name] was specified for column 1 of 'tmp_SubProdGrp'.
Server: Msg 8155, Level 16, State 1, Line 3
No column [name] was specified for column 2 of 'tmp_SubProdGrp'.

Peter Larsson
Helsingborg, Sweden

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources