SQL Server 2008 R2

Snippets

16

 

(SELECT [Value] FROM Lists where EntryID = (SELECT PropertyValue FROM UserProfile WHERE UserId = U.UserId AND PropertyDefinitionID = (SELECT PropertyDefinitionID FROM ProfilePropertyDefinition WHERE PropertyName = 'Region' AND PortalID = @PortalID)))

AS [State]

Comments

There are currently no comments, be the first to post one!

Post Comment

Only registered users may post comments.