set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[STPGridList_BankDetail_FromDate&Archive] @AccountCode int, @archiveName nvarchar(1000)=null, @FromDate char(8)='' AS SELECT FunDocumentDetail_ByAcc_Archive_FromDate_1.DetailCode, FunDocumentDetail_ByAcc_Archive_FromDate_1.AmmountIn, FunDocumentDetail_ByAcc_Archive_FromDate_1.AmmountOut, FunDocumentDetail_ByAcc_Archive_FromDate_1.UserRowNo, FunDocumentDetail_ByAcc_Archive_FromDate_1.DocDate, FunDocumentDetail_ByAcc_Archive_FromDate_1.Comment, BankDetailTbl.Number, VWCompleteCode.Title AS Snd_Title, VWCompleteCode.Title0 AS Snd_Title0, VWCompleteCode.Code0 AS Snd_Code0, FunDocumentDetail_ByAcc_Archive_FromDate_1.AmmountIn * 0 AS Remain, FunDocumentDetail_ByAcc_Archive_FromDate_1.ArchiveName, FunDocumentDetail_ByAcc_Archive_FromDate_1.SysDate, Users.UName AS UserName FROM dbo.FunDocumentDetail_ByAcc_Archive_FromDate(@AccountCode, @archiveName, @FromDate) AS FunDocumentDetail_ByAcc_Archive_FromDate_1 LEFT OUTER JOIN DocTbl ON FunDocumentDetail_ByAcc_Archive_FromDate_1.DocCode = DocTbl.SysCode LEFT OUTER JOIN Users ON DocTbl.UserIDNO = Users.UID LEFT OUTER JOIN BankDetailTbl ON FunDocumentDetail_ByAcc_Archive_FromDate_1.DetailCode = BankDetailTbl.Fk_DocDetailsyscode LEFT OUTER JOIN VWCompleteCode ON FunDocumentDetail_ByAcc_Archive_FromDate_1.SndFk_AccountSyscode = VWCompleteCode.AccountSysCode