Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails
solution works LEFT JOIN (Select VI1.GameId from #SlotVideoItems S1 Join dbo.VideoItems VI1 ON S1.[ScheduledSlotId] = @ScheduledSlotId AND S1.[VideoItemID] = VI1.[VideoItemID] Group by VI1.GameId) GM ON VI.GameID = GM.GameID AND GM.GameID is null solution doesn't work LEFT JOIN (Select VI5.GameIdtwo -- get the games already selected from #SlotVideoItems S5 Join dbo.VideoItems VI5 ON S5.[ScheduledSlotId] = @ScheduledSlotId AND S5.[VideoItemID] = VI5.[VideoItemID] Group by VI5.GameIdtwo)SV ON VI.GameIDtwo = SV.GameIDtwo AND SV.GameID is null
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
14 Experts available now in Live!