Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- WITH ViewColumn_CTE (ViewName, ColumnName) AS
- (
- SELECT TOP 100
- V.Name as ViewName,
- C.Name as ColumnName
- FROM
- sys.views V
- JOIN
- SysColumns C ON V.Object_ID = C.ID
- )
- SELECT TOP 1
- ViewName,
- ColumnName
- FROM
- ViewColumn_CTE
- WHERE
- ColumnName = 'Cash Equivalents'
Add Comment
Please, Sign In to add comment