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