I applied for a job yesterday, and they sent me a SQL test to take.  I thought all of the questions were poorly worded, but one in particular was very...

SSRS can only work with the data that you provide.  It cannot fill in gaps in your data.

Drew

Reported as spam.

This gives results similar to (but not exactly the same as) your expected results.  It's not clear why you expect the second one to match on PK_ID 5 rather than...

You haven't given us enough information to determine the problem, let alone determine how to fix it.  For instance, is group 3 showing on the following page, or is group...

I simplified things.  There is a main branch and an integration branch off of that main branch.  (This is still a simplified version.)  The bug tickets are branches off of...

Reported as spam.

We don't have a single dev branch.  We have a branch for every ticket in our system.  Only the owner of the ticket should be modifying the branch corresponding to...