USP_DATALIST_RESOURCE

                CREATE procedure dbo.USP_DATALIST_RESOURCE
                (
                    @INCLUDEINACTIVE bit = 1,
                    @RESOURCECATEGORYCODEID uniqueidentifier = null
                )
                as
                    set nocount on;

                    select
                        [RESOURCE].ID,
                        NAME,
                        QUANTITY,
                        RESOURCECATEGORYCODEID,
                        dbo.UFN_RESOURCECATEGORYCODE_GETDESCRIPTION(RESOURCECATEGORYCODEID) as RESOURCECATEGORY,
                        COALESCE([PRICINGSTRUCTURE],dbo.UFN_RESOURCEPRICING_PRICINGSTRUCTURECODE_GETDESCRIPTION(0)) as [PRICINGSTRUCTURE],
                        CASE WHEN [PRICE] <= 0 THEN null ELSE [PRICE] END as [PRICE],
                        RETURNAMOUNT,
                        ISACTIVE,
                        [DESCRIPTION]
                    from
                        dbo.[RESOURCE]
                            left join dbo.[RESOURCEPRICING] on [RESOURCE].ID = [RESOURCEPRICING].ID
                    where
                        (@INCLUDEINACTIVE = 1 or ISACTIVE = 1) AND
                        (@RESOURCECATEGORYCODEID is null or @RESOURCECATEGORYCODEID = RESOURCECATEGORYCODEID)
                    order by
                        NAME

                    return 0;