set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[STPGridList_CheckOut] @AccountCode int, @archiveName nvarchar(1000)='' AS SELECT CheckOUTTBL.SerialNo, CheckOUTTBL.Comment AS CheckComment, CheckOUTTBL.CheckDate, FunDocumentDetail_ByAcc_Archive_1.DetailCode, FunDocumentDetail_ByAcc_Archive_1.AmmountOut, FunDocumentDetail_ByAcc_Archive_1.UserRowNo, FunDocumentDetail_ByAcc_Archive_1.DocDate, FunDocumentDetail_ByAcc_Archive_1.Comment, FunDocumentDetail_ByAcc_Archive_1.ArchiveName, FunDocumentDetail_ByAcc_Archive_1.SysDate, CodeMNGDWNTbl_1.Title AS Snd_Title, [VW_LinkTo_Account&Title].LinkToTitle, CodeMNGDWNTbl.Title AS BankName, CheckOUTTBL.FK_BankAccount FROM CodeMNGDWNTbl AS CodeMNGDWNTbl INNER JOIN CheckOUTTBL ON CodeMNGDWNTbl.AccountSysCode = CheckOUTTBL.FK_BankAccount INNER JOIN dbo.FunDocumentDetail_ByAcc_Archive_FromDate(@AccountCode, @archiveName, NULL) AS FunDocumentDetail_ByAcc_Archive_1 ON CheckOUTTBL.FK_DocSysCode = FunDocumentDetail_ByAcc_Archive_1.DetailCode LEFT OUTER JOIN [VW_LinkTo_Account&Title] ON CheckOUTTBL.FK_DocSysCode = [VW_LinkTo_Account&Title].LinkFrom LEFT OUTER JOIN CodeMNGDWNTbl AS CodeMNGDWNTbl_1 ON FunDocumentDetail_ByAcc_Archive_1.SndFk_AccountSyscode = CodeMNGDWNTbl_1.AccountSysCode