USP_SETLISTSORTMETHOD

Parameters

Parameter	Parameter Type	Mode
@LISTKEY	nvarchar(100)	IN
@SORTMETHOD	tinyint	IN
@ChangeAgentID	uniqueidentifier	IN

Definition

Copy


CREATE procedure dbo.USP_SETLISTSORTMETHOD
    @LISTKEY nvarchar(100),
    @SORTMETHOD tinyint,
    @ChangeAgentID uniqueidentifier=null

with execute as caller
as   
begin
    declare @ID uniqueidentifier

    if @ChangeAgentID is null
        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @ChangeAgentID output

    select @ID = ID from dbo.LISTSORTMETHOD where LISTKEY = @LISTKEY
    if @ID is null
        begin            
            insert into dbo.LISTSORTMETHOD (LISTKEY, SORTMETHOD, ADDEDBYID, CHANGEDBYID) values (@LISTKEY, @SORTMETHOD, @ChangeAgentID, @ChangeAgentID)
        end 
    else
        update dbo.LISTSORTMETHOD set SORTMETHOD = @SORTMETHOD,CHANGEDBYID=@ChangeAgentID where LISTKEY = @LISTKEY
end