set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO







create PROCEDURE [dbo].[STPGridList_DocChange]
AS
SELECT     Users_1.UName AS OnChangeUName, ChangeDocTbl.SysCode AS DocumentCode, ChangeDocTbl.DocDate, ChangeDocTbl.SysDate, 
                      ChangeDocTbl.UserIDNO, Users.UName, ChangeDocTbl.OnChangeUserId, ChangeDocTbl.OnChangeSysDate, ChangeDocTbl.ArchiveName, 
                      ChangeDocTbl.Comment
FROM         ChangeDocTbl LEFT OUTER JOIN
                      Users AS Users_1 ON ChangeDocTbl.OnChangeUserId = Users_1.UID LEFT OUTER JOIN
                      Users ON ChangeDocTbl.UserIDNO = Users.UID