USP_DATALIST_DELIVERYMETHOD

CREATE procedure dbo.USP_DATALIST_DELIVERYMETHOD
as
    set nocount on;

    select
        ID,
        NAME,
        ISACTIVE,
        dbo.UFN_DELIVERYMETHOD_HASBEENUSED(ID) as HASBEENUSED,
        (
          select dbo.UDA_BUILDLIST(SM.TYPE)
                  from dbo.SALESMETHOD as SM
          inner join dbo.SALESMETHODDELIVERYMETHOD as SMDM
          on SM.ID = SMDM.SALESMETHODID
          inner join dbo.DELIVERYMETHOD as DM
          on DM.ID = SMDM.DELIVERYMETHODID
          where DM.ID = DELIVERYMETHOD.ID and SMDM.ISDEFAULT = 1
        )
        as ISDEFAULTFOR,
        [PRINT]
    from dbo.DELIVERYMETHOD
    order by NAME;

    return 0;