-
Notifications
You must be signed in to change notification settings - Fork 1
Open
Description
Something like this might be an easier way to review.
Select Assert.Id
, '' [ ]
, Assert.Title [Assert Title] , case when d_t.Id is null then '' else '!' end [ ] , Test.Title [Test Title]
, Assert.Author [Assert Author] , case when d_a.Id is null then '' else '!' end [ ] , Test.Author [Test Author]
From #Test Test
Join #Assert Assert on Assert.Id = Test.Id
left join #Discrepant__Title d_t on Assert.Id = d_t.Id
left join #Discrepant__Author d_a on Assert.Id = d_a.Id
Metadata
Metadata
Assignees
Labels
No labels