UFN_DOCUMENTPRINTINGRULE_SALESMETHODSLIST

This function returns document printing rule sales methods as a list given its ID.

Return

Return Type
nvarchar(200)

Parameters

Parameter	Parameter Type	Mode	Description
@DOCUMENTPRINTINGRULEID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_DOCUMENTPRINTINGRULE_SALESMETHODSLIST
            (
             @DOCUMENTPRINTINGRULEID uniqueidentifier
            )
            returns nvarchar(200) AS  

            BEGIN 
             DECLARE @SALESMETHODSLIST nvarchar(100)

             SELECT @SALESMETHODSLIST = COALESCE(@SALESMETHODSLIST + ', ', '') + (SALESMETHODLIST.[TYPE])
             FROM
               ( select SALESMETHOD.[TYPE]
                    from dbo.DOCUMENTPRINTINGRULESALESMETHOD
                        inner join dbo.SALESMETHOD on DOCUMENTPRINTINGRULESALESMETHOD.SALESMETHODID = SALESMETHOD.ID  
                    where DOCUMENTPRINTINGRULESALESMETHOD.DOCUMENTPRINTINGRULEID = @DOCUMENTPRINTINGRULEID) SALESMETHODLIST

             if @SALESMETHODSLIST is null
                set @SALESMETHODSLIST = '<None selected>';

             RETURN @SALESMETHODSLIST
            END