USP_DATALIST_PRICELIST

            create procedure dbo.USP_DATALIST_PRICELIST
            (
                    @INCLUDEINACTIVEPRICELIST bit = 0,
                    @INCLUDEINACTIVEPRICE bit = 0
            )
            as
                set nocount on;

                select 
                    ID,
                    null,
                    NAME,
                    null,
                    null,
                    1,
                    ISACTIVE,
                    DESCRIPTION,
                    null ISPARENTACTIVE,
                    null as SEQUENCE
                from
                    dbo.PRICELIST
                where
                    @INCLUDEINACTIVEPRICELIST = 1
                    or ISACTIVE = 1

                union all

                select
                    PRICE.ID,
                    PRICE.PRICELISTID,
                    null,
                    PRICETYPECODE.DESCRIPTION as PRICETYPE,
                    PRICE.FACEPRICE,
                    0,
                    null,
                    null,
                    PRICELIST.ISACTIVE ISPARENTACTIVE,
                    PRICE.SEQUENCE
                from 
                    dbo.PRICE
                inner join dbo.PRICETYPECODE on
                    PRICETYPECODE.ID = PRICE.PRICETYPECODEID
                inner join dbo.PRICELIST on
                    PRICE.PRICELISTID = PRICELIST.ID
                where
                (@INCLUDEINACTIVEPRICELIST = 1 or PRICELIST.ISACTIVE = 1)
                and
                (@INCLUDEINACTIVEPRICE = 1 or PRICETYPECODE.ACTIVE = 1)

                order by NAME, SEQUENCE

                return 0;