IF NOT EXISTS (
    SELECT 1 
    FROM INFORMATION_SCHEMA.COLUMNS 
    WHERE TABLE_NAME = 'QuotationItem' AND COLUMN_NAME = 'DeliveryTime'
)
BEGIN
	   ALTER TABLE QuotationItem
	ADD DeliveryTime  nvarchar(50) NULL ;
END
go


Create or ALTER PROCEDURE [dbo].[sp_SaveQuotation]  
@QuotationNO nvarchar(50),
   @INVCOUNT INTEGER,
 @TOTALCOUNT INTEGER  
AS
begin  
SELECT   RFQDate,Quotation.Del1,Quotation.Del2,Quotation.Del3,Quotation.Del4,Freight,Trans,Quotation.SalesMan,Quotation.AttenMob,Quotation.AttenEmail,Quotation.CustEmail,Quotation.QuotationNo,  
Quotation.EntryDate,Quotation.RefNo,Quotation.Attended,Quotation.custRefNo,Quotation.CustomerName,Quotation.CustomerCODE,Quotation.Address,Quotation.Attention,
Quotation.Telephone,Quotation.Fax,Quotation.GrossAmount,Quotation.Less,Quotation.NetAmount,Quotation.Remarks,Quotation.PaymentTerms,Quotation.Validity,
Quotation.PlaceOfDelivery,Quotation.DeliveryTime,QuotationItem.SlNo,QuotationItem.ItemName,QuotationItem.ItemCode,QuotationItem.Unit,QuotationItem.Qty,   
QuotationItem.Rate,QuotationItem.Amount,SalesMan.Mobile,SalesMan.email,ISNULL(QuotationItem.partno,'') AS partno,ISNULL(Quotation.VATNO,'') AS VATNO,ISNULL(VATTOTAL,0) AS VATTOTAL,
ISNULL(VATPER,0) AS VATPER,ISNULL(VATAMT,0) AS VATAMT ,ISNULL(QuotationItem.IDiscRate,0) AS ItemDiscOnRate
,ISNULL(C.namear,'') as Arabicname,isnull(C.address1ar,'') as ArabicAddress 
, dbo.currency_conversion(QUOTATION.NetAmount) as ARABICNETAMOUNT
,ISNULL(IDISCPER,0) AS IDISCPER,ISNULL(IDISCRATE,0) AS IDISCRATE
   ,@INVCOUNT AS INVCOUNT,@TOTALCOUNT AS TOTALINVCOUNT
   ,salesman.designation as salesmandesignation,salesman.mobile as salesmanmobile,salesman.email as salesmanemail
   ,QuotationItem.DeliveryTime as LeadTime
FROM  Quotation INNER JOIN QuotationItem ON Quotation.QuotationNo = QuotationItem.QuotationNo left join 
SalesMan on  Quotation.Attended=SalesMan.Code
 LEFT JOIN CUSTOMER C ON C.CODE=Quotation.CUSTOMERCODE
 where Quotation.QuotationNo=@QuotationNO ORDER BY QuotationItem.SlNo  
end
go