USP_REPORT_DEFAULTMAILINGHEADER

create procedure [dbo].[USP_REPORT_DEFAULTMAILINGHEADER]
(
    @ORDERID uniqueidentifier    
)
as
    set nocount on;
    set transaction isolation level read uncommitted;

    select
        CONSTITUENT.NAME,
        dbo.UFN_BUILDFULLADDRESS(ADDRESS.ID, ADDRESS.ADDRESSBLOCK, ADDRESS.CITY, ADDRESS.STATEID, ADDRESS.POSTCODE, ADDRESS.COUNTRYID) as ADDRESS,
        SALESORDER.SEQUENCEID ORDERNUMBER
    from dbo.SALESORDER 
    inner join dbo.CONSTITUENT 
        on SALESORDER.RECIPIENTID = CONSTITUENT.ID
    outer apply
        dbo.UFN_SALESORDER_CONTACTRECORDS(SALESORDER.ID) as CONTACTRECORDS
    left outer join dbo.ADDRESS 
        on CONTACTRECORDS.ADDRESSID = ADDRESS.ID
    where
        SALESORDER.ID = @ORDERID