Double post day!
The same query that had concatenation happening from the previous post also had date range parameters, @StartDate and @EndDate, and needed to only return records (which also had their own start/end date fields) in which the records’ were active during the specified date range. I.e. where the record’s date range intersected with the date range parameters. It confused me for a bit so I’m recording for posterity. As I see it, there are three possible valid cases:
Case 1: Record’s start date is within the date range
Case 3: Record’s end IS NULL (i.e. still currently active) and record’s start is less than the end of the date range