USP_SIMPLEDATALIST_COMBINATIONPRICE

            create procedure dbo.USP_SIMPLEDATALIST_COMBINATIONPRICE
            (
                @COMBINATIONID uniqueidentifier = null
            )
            as
            select 
                CPT.PRICETYPECODEID as VALUE, 
                sum(PGP.FACEPRICE) as LABEL
            from dbo.COMBINATIONPRICETYPE CPT
            inner join dbo.PROGRAMGROUPPRICE PGP on PGP.COMBINATIONPRICETYPEID = CPT.ID
            where CPT.COMBINATIONID = @COMBINATIONID
            group by CPT.PRICETYPECODEID