USP_FUNCTIONALAREA_GETADJACENTITEMS

Gets the definitions of adjacent functional areas.

Parameters

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

Definition

Copy



create procedure dbo.USP_FUNCTIONALAREA_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 = FUNCTIONALAREASPECXML,
           @ADJACENTSPECXML    = (select top 1 FA.FUNCTIONALAREASPECXML
                               from dbo.FUNCTIONALAREACATALOG FA
                               where FA.SEQUENCE < FUNCTIONALAREACATALOG.SEQUENCE
                               order by FA.SEQUENCE DESC)
    from dbo.FUNCTIONALAREACATALOG
    where ID = @ID
else
    -- select the item, and the next item

    select @SPECXML = FUNCTIONALAREASPECXML,
           @ADJACENTSPECXML    = (select top 1 FA.FUNCTIONALAREASPECXML
                               from dbo.FUNCTIONALAREACATALOG FA
                               where FA.SEQUENCE > FUNCTIONALAREACATALOG.SEQUENCE
                               order by FA.SEQUENCE)
    from dbo.FUNCTIONALAREACATALOG
    where ID = @ID

end