insert into [LCTesv9999].[#tmpm] select * from [LCTesv9999].[#tmpt] where [LinkedTDCode] not in (select [LinkedTDCode] from [cwbaseTesv].[LCTesv9999].[GSProReqs])这样写哪错了?
--try drop table [LCTesv9999].[#tmpm] select * into [LCTesv9999].[#tmpm] from [LCTesv9999].[#tmpt] where [LinkedTDCode] not in (select [LinkedTDCode] from [cwbaseTesv].[LCTesv9999].[GSProReqs])
把具体的列写出来 Insert into B(id,[status],ProductTypeId,ProductTypeName,AdvertiseId) select right(newid(),19) as id,[status],productid,ProductTypeName=(select typename from BaseProductType where id=productid),@advid as AdvertiseId from A where companyid=@comid
INSERT INTO [LCTesv9999].[#tmpm] SELECT * FROM [LCTesv9999].[#tmpt] WHERE [LinkedTDCode] NOT IN ( SELECT [LinkedTDCode] FROM [cwbaseTesv].[LCTesv9999].[GSProReqs] ) --你可以先看看这个有没有数据: SELECT * FROM [LCTesv9999].[#tmpt] WHERE [LinkedTDCode] NOT IN ( SELECT [LinkedTDCode] FROM [cwbaseTesv].[LCTesv9999].[GSProReqs] )
insert into [LCTesv9999]..[#tmpm] select * from [LCTesv9999]..[#tmpt] where [LinkedTDCode] not in (select [LinkedTDCode] from [cwbaseTesv].[LCTesv9999]..[GSProReqs])这样试试
嗯。一步一步试下查的数据。先看 select [LinkedTDCode] from [cwbaseTesv].[LCTesv9999]..[GSProReqs]中的数据。再去表#tmpt看下符合条件的数据,最后检查下表结构。
--try
drop table [LCTesv9999].[#tmpm]
select * into [LCTesv9999].[#tmpm] from [LCTesv9999].[#tmpt] where [LinkedTDCode] not in (select [LinkedTDCode] from [cwbaseTesv].[LCTesv9999].[GSProReqs])
Insert into B(id,[status],ProductTypeId,ProductTypeName,AdvertiseId) select right(newid(),19) as id,[status],productid,ProductTypeName=(select typename from BaseProductType where id=productid),@advid as AdvertiseId from A where companyid=@comid
INSERT INTO [LCTesv9999].[#tmpm]
SELECT *
FROM [LCTesv9999].[#tmpt]
WHERE [LinkedTDCode] NOT IN (
SELECT [LinkedTDCode]
FROM [cwbaseTesv].[LCTesv9999].[GSProReqs] )
--你可以先看看这个有没有数据:
SELECT *
FROM [LCTesv9999].[#tmpt]
WHERE [LinkedTDCode] NOT IN (
SELECT [LinkedTDCode]
FROM [cwbaseTesv].[LCTesv9999].[GSProReqs] )
select * from [LCTesv9999]..[#tmpt] where [LinkedTDCode] not in
(select [LinkedTDCode] from [cwbaseTesv].[LCTesv9999]..[GSProReqs])这样试试
select [LinkedTDCode] from [cwbaseTesv].[LCTesv9999]..[GSProReqs]中的数据。再去表#tmpt看下符合条件的数据,最后检查下表结构。