USP_SIMPLEDATALIST_SALESMETHOD_COMBINATION

            CREATE procedure dbo.USP_SIMPLEDATALIST_SALESMETHOD_COMBINATION
            (
                @SALESMETHODID uniqueidentifier
            )
            as
            select distinct
                C.ID as VALUE, 
                C.NAME as LABEL
            from dbo.COMBINATION C
            inner join dbo.COMBINATIONAVAILABILITY CA on CA.COMBINATIONID = C.ID
            inner join dbo.COMBINATIONAVAILABILITYSALESMETHOD CASM on CASM.COMBINATIONAVAILABILITYID = CA.ID
            where CASM.SALESMETHODID = @SALESMETHODID
            and C.ISACTIVE = 1
            order by C.NAME