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...

2- I don't see a good way to organize the SQL code in SSMS in Separate folders (like HR Code, Finance Code, Etc..). I can certainly prefix the solution/project...

You have to be careful when using words like 'never'! In my opinion, there is nothing wrong with using SELECT *...

Thanks for the update and quick reply. I'll be sure to keep an eye on this thread. Looking for the same issue. Bumped into your thread. Thanks for creating...

If someone...

• This reply was modified 3 years, 1 month ago by Phil Parkin. Reason: Correct typo

Here is another attempt, this time with dynamic column names. As mentioned before, column names must be unique, so I added some suffixes to ensure this.

DECLARE @C0...

WHERE OrderDate >= DATEADD(mm, DATEDIFF(mm, 0, GETDATE()), 0)
      AND OrderDate < DATEADD(DAY, 15, DATEADD(mm, DATEDIFF(mm, 0, GETDATE()), 0))

Thanks for your reply Phil, Someone suggested PIVOT would do this, so I was trying to figure out how to do that. While this would be the answer if...

Perhaps post a few specific questions in the SSIS forum. You need only a rudimentary knowledge of C# to achieve most of the things you'll need to use a Script...

Exporting to CSV may also solve the problem, because then you have full control over the target datatypes.

The following method is likely to be faster and easier to read than PIVOT:

(Note that column names must be unique)

SELECT PKGId = ct.PC_Pkg_Id
    ...

• This reply was modified 3 years, 1 month ago by Phil Parkin.
• This reply was modified 3 years, 1 month ago by Phil Parkin.
• This reply was modified 3 years, 1 month ago by Phil Parkin.

Try using exactly the same query as your source, but with none of the CONVERTs, and see what happens.