set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO create PROCEDURE [dbo].[STPGridList_InvoiceChange] AS SELECT Users_1.UName AS OnChangeUName, Users.UName, CodeMNGDWNTbl.Title AS AccountTitle, ChangeInvoiceTbl.CustomerName, ChangeInvoiceTbl.FK_AccountSysCode, ChangeInvoiceTbl.Comment, ChangeInvoiceTbl.InvoiceSerialNo, ChangeInvoiceTbl.RecivedDate, ChangeInvoiceTbl.DelivaredDate, ChangeInvoiceTbl.PaymentDate, ChangeInvoiceTbl.InvoiceDate, ChangeInvoiceTbl.FK_DocsysCode AS DetailSysCode, ChangeInvoiceTbl.ArchiveName, ChangeInvoiceTbl.UserNo, ChangeInvoiceTbl.InvoiceNo, ChangeInvoiceTbl.VisitorSyscode, CodeMNGDWNTbl_1.Title AS Visitor, ChangeInvoiceTbl.SysDate, InfoInvoiceType.Caption AS Type, ChangeInvoiceTbl.Amani, ChangeInvoiceTbl.OnChangeUserId, ChangeInvoiceTbl.OnChangeSysDate, ChangeInvoiceTbl.IsUpDated FROM InfoInvoiceType RIGHT OUTER JOIN ChangeInvoiceTbl ON InfoInvoiceType.Value = ChangeInvoiceTbl.Type LEFT OUTER JOIN CodeMNGDWNTbl AS CodeMNGDWNTbl_1 ON ChangeInvoiceTbl.VisitorSyscode = CodeMNGDWNTbl_1.AccountSysCode LEFT OUTER JOIN CodeMNGDWNTbl ON ChangeInvoiceTbl.FK_AccountSysCode = CodeMNGDWNTbl.AccountSysCode LEFT OUTER JOIN Users ON ChangeInvoiceTbl.UserNo = Users.UID LEFT OUTER JOIN Users AS Users_1 ON ChangeInvoiceTbl.OnChangeUserId = Users_1.UID