USP_DATALIST_ORGANIZATIONINFORMATION

CREATE procedure dbo.USP_DATALIST_ORGANIZATIONINFORMATION
as
    set nocount on;

    select ORGANIZATIONINFORMATION.ID,
           NAME,
           ADDRESSBLOCK,
           CITY,
           coalesce(DESCRIPTION, '') STATE,
           POSTCODE,
           PHONENUMBER,
           WEBADDRESS,
           EIN
    from dbo.ORGANIZATIONINFORMATION left outer join dbo.STATE on
        ORGANIZATIONINFORMATION.STATEID = STATE.ID