create procedure [dbo].[MssWebGetQuoteSummaryByQuoteId]
    @inQuoteId int
as
begin
    select
        QuoteHeader.QuoteHeaderID as QuoteId,
        CONCAT('Q-', QuoteHeader.QuoteHeaderID) as Code,
        QuoteHeader.Description as Description,
        QuoteStatus.QuoteStatusID as StatusId,
        QuoteHeader.OrderContactFID AS ContactId,
        QuoteHeader.CreatedDate as CreatedOn,
        dbo.FormatFirstNameLastName(Sysuser.FIRSTNAME, Sysuser.LASTNAME) as CreatedByName,
        LaborType.LaborType as CreatedByDesignation
    from QuoteHeader
    inner join QuoteStatus on QuoteStatus.QuoteStatusID = QuoteHeader.QuoteStatusFID
    inner join Sysuser on Sysuser.SysUserID = QuoteHeader.CreatedBySysuserFID
    inner join SysUserLaborTypeMap on SysUserLaborTypeMap.SysUserFID = Sysuser.SysUserID and SysUserLaborTypeMap.[Default] = 1
    inner join LaborType on LaborType.PriKey = SysUserLaborTypeMap.LaborTypeFID
    where QuoteHeader.QuoteHeaderID = @inQuoteId
end
GO
GRANT EXECUTE ON  [dbo].[MssWebGetQuoteSummaryByQuoteId] TO [MssExec]
GO