Guest User

Untitled

a guest
Jan 17th, 2019
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.31 KB | None | 0 0
  1. WITH ViewColumn_CTE (ViewName, ColumnName) AS
  2. (
  3. SELECT TOP 100
  4. V.Name as ViewName,
  5. C.Name as ColumnName
  6. FROM
  7. sys.views V
  8. JOIN
  9. SysColumns C ON V.Object_ID = C.ID
  10. )
  11. SELECT TOP 1
  12. ViewName,
  13. ColumnName
  14. FROM
  15. ViewColumn_CTE
  16. WHERE
  17. ColumnName = 'Cash Equivalents'
Add Comment
Please, Sign In to add comment