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