USP_INSERT_UPDATE_CRMBBENVIRONMENT

create proc USP_INSERT_UPDATE_CRMBBENVIRONMENT
@ID uniqueidentifier,
@TEXT nvarchar(200),
@ISACTIVE bit
as
begin

declare @CHANGEAGENTID uniqueidentifier;
exec dbo.[USP_CHANGEAGENT_GETORCREATECHANGEAGENT] @CHANGEAGENTID output;

IF EXISTS(SELECT 1 FROM dbo.CRMBBENVIRONMENT WHERE ID = @ID)
BEGIN
    update dbo.CRMBBENVIRONMENT
    set DESCRIPTIONTEXT = @TEXT,
        ISACTIVE = @ISACTIVE,
        CHANGEDBYID = @CHANGEAGENTID,
        DATECHANGED = GETDATE()
    where ID = @ID
END
ELSE
BEGIN
    insert into dbo.CRMBBENVIRONMENT(ID,DESCRIPTIONTEXT,ISACTIVE,ADDEDBYID,CHANGEDBYID) 
    values(@ID,@TEXT,@ISACTIVE,@CHANGEAGENTID,@CHANGEAGENTID)
END

end