DECLARE @aa NVARCHAR(100)
SELECT TOP 1
@aa = RIGHT(Chat, LEN(Chat) - CHARINDEX('救', Chat))
FROM [Center].[dbo].[_Logat]
WHERE ACCID = @StrACCIDjiu
ORDER BY Time DESC
SELECT ACJCID
FROM ZARD.dbo._User
WHERE CHARID IN ( SELECT CharID
FROM [ZARD].[dbo].[_Cjax]
WHERE Name = @aa )
SELECT TOP 1 right(l.Chat, len(l.Chat) - charindex('救',l.Chat)) as aa
FROM [Center].[dbo].[_Logat] AS l
LEFT JOIN [ZARD].[dbo].[_Cjax] AS c ON c.Name=right(l.Chat, len(l.Chat) - charindex('救',l.Chat))
LEFT JOIN ZARD.dbo._User AS u ON u.CHARID=c.CharID
WHERE l.ACCID=@StrACCIDjiu ORDER BY Time DESC
