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