USP_STATE_GETABBREVIATIONANDCOUNTRYLIST

            create procedure dbo.USP_STATE_GETABBREVIATIONANDCOUNTRYLIST
            as
                set nocount on;

                select 
                    STATE.ID as STATEID,
                    STATE.ABBREVIATION as STATEABBREVIATION,
                    COUNTRY.ID as COUNTRYID,
                    COUNTRY.DESCRIPTION as COUNTRY
                from 
                    dbo.STATE
                inner join 
                    dbo.COUNTRY on STATE.COUNTRYID = COUNTRY.ID;

                return 0;