CREATE   PROCEDURE [dbo].[sp_SaveSalesOrder]
(
@SalesOrderNoP nvarchar(50),
@BranchCode varchar(10)
)
AS  
begin  
SELECT   RFQDate,SalesOrder.Del1,SalesOrder.Del2,SalesOrder.Del3,SalesOrder.Del4,Freight,Trans,SalesOrder.SalesMan,SalesOrder.AttenMob,SalesOrder.AttenEmail,SalesOrder.CustEmail,SalesOrder.SalesOrderNo,  
SalesOrder.EntryDate,SalesOrder.RefNo,SalesOrder.Attended,SalesOrder.custRefNo,SalesOrder.CustomerName,SalesOrder.CustomerCode,SalesOrder.Address,SalesOrder.Attention,
SalesOrder.Telephone,SalesOrder.Fax,SalesOrder.GrossAmount,SalesOrder.NETDISC as LESS,SalesOrder.NetAmount,SalesOrder.Remarks,SalesOrder.PaymentTerms,SalesOrder.Validity,
SalesOrder.PlaceOfDelivery,SalesOrder.DeliveryTime,SalesOrderItem.SlNo,SalesOrderItem.ItemName,SalesOrderItem.ItemCode,SalesOrderItem.Unit,SalesOrderItem.Qty,   
SalesOrderItem.Rate,SalesOrderItem.Amount,SalesMan.Mobile,SalesMan.email,ISNULL(SalesOrderItem.partno,'') AS partno,ISNULL(SalesOrder.Vatno,'') AS VATNO,ISNULL(SalesOrder.Vattotal,0) AS VATTOTAL,
ISNULL(SalesOrderItem.Vatper,0) AS VATPER,ISNULL(SalesOrderItem.VatAmt,0) AS VATAMT 
,ISNULL(C.NameAR,'') as Arabicname,isnull(C.Address1AR,'') as ArabicAddress 
, dbo.currency_conversion(SalesOrder.NetAmount) as ARABICNETAMOUNT
  ,isnull(logoimage,'')as logoimage,isnull(signatureimage,'')as signatureimage,isnull(sealimage,'')as sealimage,isnull(footerimage,'')as footerimage,isnull(headderimage,'')as headderimage,
j.Model,j.JobCardDate,j.PlateNo,i.Category
FROM  SalesOrder 
INNER JOIN SalesOrderItem ON SalesOrder.SalesOrderNo = SalesOrderItem.SalesOrderNo left join 
SalesMan on  SalesOrder.Attended=SalesMan.Code
 LEFT JOIN CUSTOMER C ON C.CODE=SalesOrder.CUSTOMERCODE
 JOIN Companydetails CD ON ISNULL(CD.BranchCode,@BranchCode)=@BranchCode
 LEFT JOIN JOBCARD J ON J.jobcardno=SalesOrder.JobcardNo
 Left join item i on i.itemcode=SalesOrderItem.ItemCode
 where SalesOrder.SalesOrderNo=@SalesOrderNoP ORDER BY SalesOrderItem.SlNo  
end  


GO