sum function

Try this please

ALTER PROCEDURE [dbo].[Sp_GetQuoteNoforSO]
  @QuoteNo as int
 AS
 BEGIN
 
 Select 
 Q.CompanyName,
  Q.CompAddress,
  Q.ClientName,
         Q.Total,
  sum(QD.Quantity)
     
   
  from Quotation Q 
inner join
  QuoteDetail QD on
  Q.QuoteNo=4 and QD.QuoteNumber=4
group by 
Q.CompanyName,
  Q.CompAddress,
  Q.ClientName,
         Q.Total

---

http://sqldevelop.wordpress.com/