USP_SIMPLEDATALIST_ZIPCITYSTATECOUNTRY

                CREATE procedure dbo.USP_SIMPLEDATALIST_ZIPCITYSTATECOUNTRY
                as
                    set nocount on;

                    select distinct
                        COUNTRY.ID as VALUE,
                        COUNTRY.DESCRIPTION as LABEL
                    from 
                        dbo.ZIPCITYSTATE ZCS
                    inner join
                        dbo.COUNTRY on ZCS.COUNTRYID = COUNTRY.ID
                    order by 
                        COUNTRY.DESCRIPTION;