Hi,
I'm going to update and insert a record into two different tables using one sql query.
How can I do this? Any help and tips would be much apprexiated. Thanks in advance. :D
Here's my query:
USE [MIS]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[Update_Offer]
@offer_ID as int,
@offer as varchar(100),
@validity as varchar(100),
@collaterals varchar(100),
@created_by as varchar(100),
@remarks as varchar(100)
AS
BEGIN
UPDATE Offer3
SET
[offer]=@offer,
[validity]=@validity,
[collaterals]=@collaterals,
[created_by]=@created_by
WHERE [offer_ID] = @offer_ID
INSERT INTO [Program_Offer]
(
[offer_ID],
[remarks]
)
SELECT
@offer_ID,
@remarks
END
And I'm receiving an error that says "procedure has too many ...
Go to the complete details ...