Yes, conn managers should be checked in with dev / local connections and that is how they should remain, as far as source control is concerned.

After deploying packages to QA...

This line looks weird. What is it supposed to do? Strings and INTs mixed in the same list?

where o.status dbo.in ('D',1,2,3,4,5)

Righto. Have you considered creating a post like this?

"I am trying to import some XML files into SQL Server tables, but I am not sure how best to...

Yes it can... so can C#, Visual Basic,...

Yes it can... so can C#, Visual Basic,...

What sort of feedback are you expecting? If someone here says 'Yep, looks good', does that mean you will push the code to Production?

And when there's a problem, you'll be...

Jeff, that's nice work. Thanks for reminding me of ROLLUP and GROUPING too.

There is no syntax error in that code. I just copy/pasted and ran it to be sure that the rendering had not affected anything.

Which version of SQL Server are you...

Please post a question only once. Answers here please.

If a date is between '01/01/2022' and '09/01/2022', it cannot also be between '01/01/2006' and '01/01/2017'. You need to rethink your logic, as this will never produce any results.

Let's introduce some test data. Please try running this and tell me whether it gives you what you want.

DROP TABLE IF EXISTS #Trips;

CREATE TABLE #Trips
(
  ...

Something like this, perhaps?

SELECT Mth = MONTH(t.start_date)
      ,t.IsMember
      ,TotalTrips = COUNT(*)
FROM trips t
WHERE YEAR(t.start_date) = 2017
 ...

If there's a lot of data involved and you're likely to be running regular analyses on it, I'd consider setting this up in a Tabular Model and using DAX...

Without knowing the structure of your tables, this is impossible to answer with any certainly.

In line with Jeff's question, I would have expected 'Last week actuals' to be, in pseudo-code:

It seems my insistence on unique column names was misguided. This is not required.

I am using a temp table while working on your code. Please try executing the following and...