No data in database view of versioned feature class

[ChrisWiebke]

If I have a view of versioned data how do i get the view to return data before the feature class it references is reconciled with the default version of the geodatabase?

[George_Thompson]

You need to be set the version that you want to see in the view; Read versioned data in SQL Server using versioned views—Help | ArcGIS Desktop 

That should get you what you want.

[ChrisWiebke]

I am able to do that in a ssms query window, but the view I created always reads from default.  I would like to be able to specify which version of the geodatabase the view reads from.  Thanks.

[George_Thompson]

You need to create a view in SSMS and put that SQL to change the version in the view.

[ChrisWiebke]

I used this to create the view:

USE [Our Database]
GO

EXEC database.sde.set_current_version 'the version'

/****** view info******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

but when I script out the view to a new query window, the exec is not there:

USE [Our Database]
GO

/****** view info******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

is there something else I need to do?

Thanks.