insert 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

General SQL Server Forums

New to SQL Server Programming

insert into

Author

Topic

chriztoph
Posting Yak Master

184 Posts

Posted - 2009-11-16 : 01:00:49

Hi,i have problem on this query..
iwant to insert data of a table to another database table..

Errors:
Msg 116, Level 16, State 1, Procedure prcUploadSODetails, Line 68
Only one expression can be specified in the select list when the subquery is not introduced with EXISTS.
Msg 109, Level 15, State 1, Procedure prcUploadSODetails, Line 52
There are more columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES clause must match the number of columns specified in the INSERT statement.


ALTER PROCEDURE [dbo].[prcUploadSODetails]
@SONo as Varchar(20)
AS

BEGIN
	Insert Into TRIACS_PLUS.dbo.trnSalesOrderDetails
	(SONo,
	Passengers,
	ProfitCenterID,
	DetailTypeID,
	GrossQty,
	GrossCurrID,
	GrossInit,
	GrossTotal,
	NetQty,
	NetCurrID,
	NetInit,
	NetTotal,
	TicketNo,
	AppliedAmt,
	MIRNo,
	OriginalPrice,
	Insurance)
	select TRIACS_PLUS_TEST.dbo.trnSalesOrderDetails.SONo, 
	TRIACS_PLUS_TEST.dbo.trnSalesOrderDetails.Passengers, 
	TRIACS_PLUS_TEST.dbo.trnSalesOrderDetails.ProfitCenterID, 
	TRIACS_PLUS_TEST.dbo.trnSalesOrderDetails.DetailTypeID, 
	TRIACS_PLUS_TEST.dbo.trnSalesOrderDetails.GrossQty, 
	TRIACS_PLUS_TEST.dbo.trnSalesOrderDetails.GrossCurrID, 
	TRIACS_PLUS_TEST.dbo.trnSalesOrderDetails.GrossInit, 
	TRIACS_PLUS_TEST.dbo.trnSalesOrderDetails.GrossTotal, 
	TRIACS_PLUS_TEST.dbo.trnSalesOrderDetails.NetQty, 
	TRIACS_PLUS_TEST.dbo.trnSalesOrderDetails.NetCurrID, 
	TRIACS_PLUS_TEST.dbo.trnSalesOrderDetails.NetInit, 
	TRIACS_PLUS_TEST.dbo.trnSalesOrderDetails.NetTotal, 
	TRIACS_PLUS_TEST.dbo.trnSalesOrderDetails.TicketNo, 
	TRIACS_PLUS_TEST.dbo.trnSalesOrderDetails.AppliedAmt, 
	TRIACS_PLUS_TEST.dbo.trnSalesOrderDetails.MIRNo, 
	TRIACS_PLUS_TEST.dbo.trnSalesOrderDetails.OriginalPrice, 
	TRIACS_PLUS_TEST.dbo.trnSalesOrderDetails.Insurance 
	from TRIACS_PLUS_TEST.dbo.trnSalesOrderDetails
	where TRIACS_PLUS_TEST.dbo.trnSalesOrderDetails.SONo = @SONo
	
END

BEGIN
	INSERT INTO trnSalesOrderParticulars
	(DetailID,
	ProfitCenterID,
	AirlineID,
	Itinerary,
	SupplierID,
	RoomTypeID,
	CarTypeID,
	DocTypeID,
	DepDate,                       
	Notes,
	SONo)
	VALUES(@@IDENTITY,
	(SELECT ProfitCenterID,AirlineID,Itinerary,SupplierID,
		RoomTypeID,CarTypeID,DocTypeID,DepDate,Notes,SONo 
	FROM TRIACS_PLUS_TEST.dbo.vwGetUploadParticulars
	where SONo = @SONo))
	
END

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-11-16 : 01:59:41

Seconf insert should be


INSERT INTO trnSalesOrderParticulars
	(DetailID,
	ProfitCenterID,
	AirlineID,
	Itinerary,
	SupplierID,
	RoomTypeID,
	CarTypeID,
	DocTypeID,
	DepDate,                       
	Notes,
	SONo)
	
	SELECT @@IDENTITY,ProfitCenterID,AirlineID,Itinerary,SupplierID,
		RoomTypeID,CarTypeID,DocTypeID,DepDate,Notes,SONo 
	FROM TRIACS_PLUS_TEST.dbo.vwGetUploadParticulars
	where SONo = @SONo

Madhivanan

Failing to plan is Planning to fail

chriztoph
Posting Yak Master

184 Posts

Posted - 2009-11-16 : 02:45:16

thanks madhivanan..

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources