Do you work with and analyze data? Enroll in October's Course of the Month for 7+ hours of SQL training, allowing you to quickly and efficiently store or retrieve data. It's free for Premium Members, Team Accounts, and Qualified Experts!
SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO Create PROCEDURE [dbo].[INSERT_ControlTrans] @idofcontrol BIGINT, @idofucid BIGINT, @IdOfUser BIGINT AS Declare @Activeorg bigint exec dbo.GET_Active_Userorganisation @UserID=@idofUser,@Organisation=@Activeorg output DECLARE @InsertedId BIGINT INSERT INTO dbo.ControlTrans (ControlID, UCID, UserID, Organisation, ControlDisplayName, CreatedDate , UpdatedDate, Status) Output Inserted.ControlTransID INTO @InsertedId(ControlTransID) VALUES (@idofcontrol, @idofucid, @IdOfUser, @Activeorg, (select ControlName+ ',' + GETDATE() from [dbo].[SHOW_UserOrganisationControlLocationObjectQuestion] where ControlID=@idofcontrol and UserID=@IdofUser and Organisation=@Activeorg), GETDATE(), GETDATE(), 0 ) GO
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.