USP_TASK_GETADJACENTITEMS

Gets the definitions of adjacent tasks.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@PREVIOUS	bit	IN
@SPECXML	xml	INOUT
@ADJACENTSPECXML	xml	INOUT

Definition

Copy



create procedure dbo.USP_TASK_GETADJACENTITEMS (
    @ID uniqueidentifier, 
    @PREVIOUS bit, 
    @SPECXML xml output, 
    @ADJACENTSPECXML xml output)
as
begin

if @PREVIOUS = 1
    -- select the item, and the previous item

    select @SPECXML = TASKSPECXML,
           @ADJACENTSPECXML    = (select top 1 T.TASKSPECXML
                               from dbo.TASKCATALOG T
                               where (T.TASKGROUP = TASKCATALOG.TASKGROUP) and (T.SEQUENCE < TASKCATALOG.SEQUENCE)
                               order by T.SEQUENCE DESC)
    from dbo.TASKCATALOG
    where ID = @ID
else
    -- select the item, and the next item

    select @SPECXML = TASKSPECXML,
           @ADJACENTSPECXML    = (select top 1 T.TASKSPECXML
                               from dbo.TASKCATALOG T
                               where (T.TASKGROUP = TASKCATALOG.TASKGROUP) and (T.SEQUENCE > TASKCATALOG.SEQUENCE)
                               order by T.SEQUENCE)
    from dbo.TASKCATALOG
    where ID = @ID

end