USP_REPORT_DEFAULTITEMIZEDRECEIPT_GETORGANIZATIONINFORMATION

create procedure [dbo].[USP_REPORT_DEFAULTITEMIZEDRECEIPT_GETORGANIZATIONINFORMATION]                
as
    set nocount on;
    set transaction isolation level read uncommitted;

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

    return 0;