set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[STPGridList_Account_DocDetail_ByArchiveFromDate] @AccountCode int , @archiveName nvarchar(1000)=null, @FromDate varChar(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, FunDocumentDetail_ByAcc_Archive_FromDate_1.ArchiveName, FunDocumentDetail_ByAcc_Archive_FromDate_1.SysDate, CodeMNGDWNTbl.Title AS Snd_Tilte, FunDocumentDetail_ByAcc_Archive_FromDate_1.AmmountIn * 0 AS Remain, Users.UName FROM CodeMNGDWNTbl RIGHT OUTER JOIN dbo.FunDocumentDetail_ByAcc_Archive_FromDate(@AccountCode, @archiveName, @FromDate) AS FunDocumentDetail_ByAcc_Archive_FromDate_1 LEFT OUTER JOIN Users INNER JOIN DocTbl ON Users.UID = DocTbl.UserIDNO ON FunDocumentDetail_ByAcc_Archive_FromDate_1.DocCode = DocTbl.SysCode ON CodeMNGDWNTbl.AccountSysCode = FunDocumentDetail_ByAcc_Archive_FromDate_1.SndFk_AccountSyscode