UFN_SALESMETHODDELIVERYMETHOD_GETDEFAULTDELIVERYMETHODID

            create function dbo.UFN_SALESMETHODDELIVERYMETHOD_GETDEFAULTDELIVERYMETHODID (
                @SALESMETHODTYPECODE tinyint
            )
            returns uniqueidentifier
            with execute as caller
            as begin
                declare @DEFAULTDELIVERYMETHODID uniqueidentifier;

                select @DEFAULTDELIVERYMETHODID = DELIVERYMETHODID
                from dbo.SALESMETHODDELIVERYMETHOD 
                inner join dbo.SALESMETHOD on 
                    SALESMETHODDELIVERYMETHOD.SALESMETHODID = SALESMETHOD.ID
                where 
                    SALESMETHOD.TYPECODE = @SALESMETHODTYPECODE and 
                    SALESMETHODDELIVERYMETHOD.ISDEFAULT = 1;

                return @DEFAULTDELIVERYMETHODID;
            end