Вопросы и ответы о сайте для программистов
SELECT DISTINCT ph.PostId AS [Post Link], 'site://posts/' + CAST(ph.PostId AS varchar)+'/revisions' AS [Revision History] FROM PostHistory ph WHERE (ph.UserDisplayName='user' + Convert(nvarchar(20), ##UserId##)) ORDER BY ph.PostId DESC