USP_SIMPLEDATALIST_DELIVERYMETHOD_NOTBLOCKEDFORORDER

                CREATE procedure dbo.USP_SIMPLEDATALIST_DELIVERYMETHOD_NOTBLOCKEDFORORDER
                (
                    @ORDERID uniqueidentifier = null
                ) as

                declare @SALESMETHODID uniqueidentifier;
                select @SALESMETHODID = dbo.UFN_SALESMETHOD_GETIDFROMTYPECODE(SALESMETHODTYPECODE)
                from dbo.SALESORDER
                where ID = @ORDERID;

                select 
                    DM.ID as VALUE,
                    case SMDM.ISDEFAULT
                        when 0 then DM.NAME
                        else DM.NAME + ' (Default)'
                    end as LABEL
                from dbo.DELIVERYMETHOD as DM
                inner join dbo.SALESMETHODDELIVERYMETHOD as SMDM on SMDM.DELIVERYMETHODID = DM.ID
                where 
                    SMDM.SALESMETHODID = @SALESMETHODID and
                    dbo.UFN_DELIVERYMETHOD_VALIDFORORDER(DM.ID, @ORDERID) = 1