UFN_MARKINGCOLUMN_GETMARKINGCOLUMN

Returns the marking columns in a marking column set.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@MARKINGCOLUMNSETID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.UFN_MARKINGCOLUMN_GETMARKINGCOLUMN( @MARKINGCOLUMNSETID uniqueidentifier )
returns table
as return(

    select 
        MARKINGCOLUMN.ID,
        MARKINGCOLUMNDESCRIPTIONCODEID,
        DISPLAYNAME,
        MARKINGCOLUMNDESCRIPTIONCODE.SEQUENCE
    from 
        dbo.MARKINGCOLUMN
    join 
        dbo.MARKINGCOLUMNDESCRIPTIONCODE on MARKINGCOLUMNDESCRIPTIONCODE.ID = MARKINGCOLUMN.MARKINGCOLUMNDESCRIPTIONCODEID
    where 
        MARKINGCOLUMNSETID = @MARKINGCOLUMNSETID

    )