set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[STPGridList_DocDetail_ByArchiveFromDate] @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_1.Title AS Snd_Tilte, FunDocumentDetail_ByAcc_Archive_FromDate_1.AccountCode, VWCompleteCode.Title, VWCompleteCode.Title0, FunDocumentDetail_ByAcc_Archive_FromDate_1.AmmountIn * 0 AS Remain, FunDocumentDetail_ByAcc_Archive_FromDate_1.DocCode, Users.UName FROM CodeMNGDWNTbl AS CodeMNGDWNTbl_1 RIGHT OUTER JOIN dbo.FunDocumentDetail_Archive_FromDate(NULL, @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 LEFT OUTER JOIN VWCompleteCode ON FunDocumentDetail_ByAcc_Archive_FromDate_1.AccountCode = VWCompleteCode.AccountSysCode ON CodeMNGDWNTbl_1.AccountSysCode = FunDocumentDetail_ByAcc_Archive_FromDate_1.SndFk_AccountSyscode