MS SQL- View of a Version

Anonymous User — Wed, 21 Feb 2018 17:43:47 GMT

I want to make saved views of the data my contractor has edited in SQL Server Management Studio so I can delegate watching a contractor's progress to a person who can just see it in front of them easily. The contractor's data is in a child version. I can seem to make a query that works but not a view that I can save within the database. This is the sql query that works:

USE [DatabaseName]

EXEC dbo.set_current_version'UserNameValueHere.VersionNameValueHere'

SELECT *

FROM [dbo].[StormwaterPipe_evw]

WHERE (created_user = 'UserNameValueHere' or last_edited_user = 'UserNameValueHere') AND (created_date >= '2018-02-01' or last_edited_date >= '2018-02-01')

ORDER BY created_date

topic MS SQL- View of a Version in Admin Tools Questions

MS SQL- View of a Version