Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE VIEW FeedView AS
- SELECT Id, [Type] = 1, DateCreated
- FROM NewsBlog
- UNION ALL
- SELECT Id, [Type] = 2, DatePublished AS DateCreated
- FROM NewsReport
- UserFeedView Table
- FeedViewId, UserId
- SELECT TOP 20 FV.*, UFV.UserId
- FROM FeedView FV
- LEFT OUTER JOIN UserFeedView UFV ON UFV.FeedViewId = FV.Id
- WHERE UFV.UserId IS NULL OR UFV.UserId = '3D976E26-F9C9-4470-9CD7-DD9A79F29514'
- ORDER BY FV.DateCreated DESC
Add Comment
Please, Sign In to add comment