USP_MKTSOURCECODEPART_SWAPSOURCECODEPARTS
Swaps the sequence of two source code parts in a layout.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @TOPSOURCECODEITEMID | uniqueidentifier | IN | |
| @BOTTOMSOURCECODEITEMID | uniqueidentifier | IN | |
| @CHANGEAGENTID | uniqueidentifier | IN |
Definition
Copy
create procedure dbo.[USP_MKTSOURCECODEPART_SWAPSOURCECODEPARTS]
(
@TOPSOURCECODEITEMID uniqueidentifier,
@BOTTOMSOURCECODEITEMID uniqueidentifier,
@CHANGEAGENTID uniqueidentifier = null
)
as
set nocount on;
declare @CURRENTDATE datetime;
if @CHANGEAGENTID is null
exec dbo.[USP_CHANGEAGENT_GETORCREATECHANGEAGENT] @CHANGEAGENTID output;
set @CURRENTDATE = getdate();
/* Swap the sequences */
update dbo.[MKTSOURCECODEITEM]
set [SEQUENCE] = [SEQUENCE] + 1, [CHANGEDBYID] = @CHANGEAGENTID, [DATECHANGED] = @CURRENTDATE
where [ID] = @TOPSOURCECODEITEMID;
update dbo.[MKTSOURCECODEITEM]
set [SEQUENCE] = [SEQUENCE] - 1, [CHANGEDBYID] = @CHANGEAGENTID, [DATECHANGED] = @CURRENTDATE
where [ID] = @BOTTOMSOURCECODEITEMID;
return 0;