USP_SIMPLEDATALIST_TAXID_STATE_ABBREVIATION
Returns abbreviations for all states that have a TaxID with an active status.
Definition
Copy
CREATE procedure dbo.USP_SIMPLEDATALIST_TAXID_STATE_ABBREVIATION as
select S.ID as Value, S.ABBREVIATION as Label
from STATE S
join TAXID T on S.ID = T.STATEID
where T.ENTITYTYPECODE = 1
and T.STATUSCODE = 1
order by S.ABBREVIATION