Guest User

Untitled

a guest
Jun 18th, 2018
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.41 KB | None | 0 0
  1. CREATE VIEW FeedView AS
  2. SELECT Id, [Type] = 1, DateCreated
  3. FROM NewsBlog
  4.  
  5. UNION ALL
  6.  
  7. SELECT Id, [Type] = 2, DatePublished AS DateCreated
  8. FROM NewsReport
  9.  
  10. UserFeedView Table
  11. FeedViewId, UserId
  12.  
  13. SELECT TOP 20 FV.*, UFV.UserId
  14. FROM FeedView FV
  15. LEFT OUTER JOIN UserFeedView UFV ON UFV.FeedViewId = FV.Id
  16. WHERE UFV.UserId IS NULL OR UFV.UserId = '3D976E26-F9C9-4470-9CD7-DD9A79F29514'
  17. ORDER BY FV.DateCreated DESC
Add Comment
Please, Sign In to add comment