Avatar of tbaseflug
tbaseflug
Flag for United States of America

asked on 

Get Scope Id

Is there anythign wrong with what I am doing below - just trying to grab the scope ID of teh inserted value in a sproc
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

Open in new window

Microsoft SQL ServerMicrosoft SQL Server 2005

Avatar of undefined
Last Comment
chapmandew

8/22/2022 - Mon