I spend a lot of time in the [sql-server](https://stackoverflow.com/questions/tagged/sql-server "show questions tagged 'sql-server'") tag and see a lot of questions that don't provide the basics, including: schema, dummy data and desired output.

I decided to [self-answer a question](https://stackoverflow.com/questions/46491717/sharing-a-sql-server-issue-with-someone-that-cant-access-my-database) with a community wiki answer, that I could use as a pointer for users that may not be aware of how they could help themselves.

It was suggested in comments that the Q&A should have been placed on meta, so I'm here to verify if what I've done is OK.