Update, I was wrong. neither NOCOUNT ON nor XACT_ABORT ON were causing it. I added  SET TRANSACTION ISOLATION LEVEL SERIALIZABLE and WITH (updlock) and that produced no duplicates. Per this article 

Well, I got it. 

SELECT 'Audit Report' AS [Subject],
(
SELECT STUFF((
SELECT ';' + Email
FROM ReportSubscription a
WHERE a.ReportGroup IN ('To')
        AND a.Active = 1
FOR...

Thank you Jason. I had concocted a long CROSS APPLY method, but this FIRST_VALUE function is awesome. Thank you,

Amy

Geoff,

To be perfectly honest, I'm not really sure why you're solution worked, but it did. Wait, I think I got it, but I don't know if I'd ever have...

The report data is populated from a stored procedure. But in order to populate the drop down list, I set up another dataset from a query.

SELECT DISTINCT cipcode,...

Thank you again for helping me find a solution, Chris. I ran your new query against the older one, and the execution plans using the source data are attached. ...

Thank you Chris. I've just added another person to the temp table. Person #4 makes $45.00 exactly working at two different jobs. Using ROW_NUMBER, we get one row...

Chris, You've probably forgotten all about this, but after some other projects finished, I finally got back to this. I ran into a problem I hadn't thought of. There are...

Chris, Thank you for this article. I have been trying to figure out a solution to a problem I've had for a while, and could only come up with work...

I can't believe this. My query went from nearly 10 minutes to 2 seconds. I had this idea that the data had to be summed before joining. The dangers of...

Oops, I think I misunderstood something. The data are in two separate tables that...

OK, thank you for the link on ancient ceramic toilets 😛 But anyway, you are asking why don't I just put it in a regular table? Correct? The answer...

I'm sorry, but I don't know what a bog is (relating to SQL, that is). I googled it, and didn't see anything obvious.

Alan.B. -- not only did it work, but I learned something completely new. Thank you.

Amy

Thank you for this solution. I had originally tried to do a recursive cte, but though I'm beginning to understand how they work, I haven't been able to succussfully...