query problem?

[nowayout]

insert into op_apps_daily.dbo.chktype values (select * from norway.dbo.chktype)
where norway.dbo.chktype.code not in (op_apps_daily.dbo.chktype)

i am getting error at select statement

what is wrong?
??

 

[tlbroadbent]

You don't use a values clause when the source of the data is a select statement. See SQL BOL for an explanation of Insert.

insert into op_apps_daily.dbo.chktype
select * from norway.dbo.chktype If you want to get the best answer for your question read faq183-874 and thread183-468158.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

 

[bs26]

insert into op_apps_daily.dbo.chktype select * from norway.dbo.chktype
where norway.dbo.chktype.code not in (op_apps_daily.dbo.chktype)

 

[tlbroadbent]

The where clause will not work, either. You must use column names not table names. NOT Exists is better than NOT IN. NOT IN can return erroneous results.

Where NOT EXISTS
(Select * From op_apps_daily.dbo.chktype
Where keycol = norway.dbo.chktype.keycol)

If you want to get the best answer for your question read faq183-874 and thread183-468158.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm