USP_REPORT_DEFAULTWILLCALLHEADER

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

    select
        case
            when coalesce(CONSTITUENT.FIRSTNAME, '') <> '' then
                CONSTITUENT.KEYNAME + ', ' + CONSTITUENT.FIRSTNAME
            else
                CONSTITUENT.KEYNAME
        end
        CONSITUENTNAME,                        
        SALESORDER.SALESMETHODTYPE,
        SALESORDER.SEQUENCEID ORDERNUMBER
    from
        dbo.SALESORDER inner join dbo.CONSTITUENT on 
            SALESORDER.RECIPIENTID = CONSTITUENT.ID
    where
        SALESORDER.ID = @ORDERID;

    return 0;