asked on
BEGIN
INSERT INTO Pricing_tblRevenue_RunHistory
(
ITERATION_ID,
RUN_DATE,
CDM_DATE,
RUN_TYPE,
RUN_START_DATE,
RUN_END_DATE,
RUN_EXEC_BY
)
VALUES (
@IterationID,
GETDATE(),
@DATE_STAMP,
@RUN_TYPE,
@TRANS_DT_LOW,
@TRANS_DT_HIGH,
@User
)
DECLARE @runID int
SELECT @runID = SCOPE_IDENTITY()
END