set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO







ALTER PROCEDURE [dbo].[STPGridList_Documents]
AS
SELECT     Users.UName, DocTbl.Lock, DocTbl.ArchiveName, DocTbl.Comment, DocTbl.SysDate, DocTbl.DocDate, DocTbl.SysCode, Details.Rows, 
                      Details.Amount
FROM         DocTbl LEFT OUTER JOIN
                          (SELECT     COUNT(Syscode) AS Rows, Fk_docSysCode, SUM(AmmountIN) AS Amount
                             FROM         DocDetailTbl
                             GROUP BY Fk_docSysCode) AS Details ON DocTbl.SysCode = Details.Fk_docSysCode LEFT OUTER JOIN
                      Users ON DocTbl.UserIDNO = Users.UID