UFN_SIMPLEACKNOWLEDGEMENT_GETSOLICITCODES

CREATE function dbo.UFN_SIMPLEACKNOWLEDGEMENT_GETSOLICITCODES
(
    @SEGMENTATIONID uniqueidentifier
)
returns @SOLICITCODES table (ID uniqueidentifier, SOLICITCODEID uniqueidentifier, NAME nvarchar(200), TYPE tinyint)
as    
begin

    insert into @SOLICITCODES(ID, SOLICITCODEID, NAME, TYPE) 
        select
            null as ID,
            ID as SOLICITCODEID,
            DESCRIPTION as NAME,
            EXCLUSIONCODE as TYPE
        from dbo.SOLICITCODE
        where EXCLUSIONCODE = 2;

    insert into @SOLICITCODES(ID, SOLICITCODEID, NAME, TYPE) 
        select
            SIMPLEACKNOWLEDGEMENTSOLICITCODES.ID,
            SIMPLEACKNOWLEDGEMENTSOLICITCODES.SOLICITCODEID,
            SOLICITCODE.DESCRIPTION as NAME,
            SOLICITCODE.EXCLUSIONCODE as TYPE
        from dbo.SIMPLEACKNOWLEDGEMENTSOLICITCODES
        inner join dbo.SOLICITCODE 
            on SIMPLEACKNOWLEDGEMENTSOLICITCODES.SOLICITCODEID = SOLICITCODE.ID
        where SIMPLEACKNOWLEDGEMENTSOLICITCODES.SEGMENTATIONID = @SEGMENTATIONID
            and SOLICITCODE.EXCLUSIONCODE <> 2;

      return;
 end