USP_SIMPLEDATALIST_FEPSURVEYYEAR

Provides a list of years with data from the Fundraising Effectiveness Project.

Definition

Copy 


                CREATE procedure dbo.USP_SIMPLEDATALIST_FEPSURVEYYEAR as
                    select
                        distinct(dense_rank() over(order by SURVEYYEAR desc)) as VALUE,
                        SURVEYYEAR as LABEL
                    from dbo.FEPDATA
                    order by SURVEYYEAR desc