UFN_SALESMETHODDELIVERYMETHOD_GETDEFAULTDELIVERYMETHOD

Returns the default delivery method for a given sales method.

Return

Return Type
nvarchar(100)

Parameters

Parameter	Parameter Type	Mode	Description
@SALESMETHODTYPECODE	tinyint	IN

Definition

Copy



            CREATE function dbo.UFN_SALESMETHODDELIVERYMETHOD_GETDEFAULTDELIVERYMETHOD
            (
                @SALESMETHODTYPECODE tinyint
            )
            returns nvarchar(100)

            with execute as caller
            as begin
                declare @DEFAULTDELIVERYMETHODID uniqueidentifier = dbo.UFN_SALESMETHODDELIVERYMETHOD_GETDEFAULTDELIVERYMETHODID(@SALESMETHODTYPECODE);
                declare @DEFAULTDELIVERYMETHODNAME nvarchar(100);

                select @DEFAULTDELIVERYMETHODNAME = DELIVERYMETHOD.NAME
                from dbo.DELIVERYMETHOD
                where ID = @DEFAULTDELIVERYMETHODID;

                return @DEFAULTDELIVERYMETHODNAME
            end