Thank you much Johan, I will follow your guidelines. Thank you

Good Morning,

I started here but still need to go if any techniques that would be great

;WITH CTE1 AS
(
SELECT YEAR(DateofJoin) AS [YEAR],MONTH(DateofJoin) AS [MONTH],COUNT(DateofJoin) AS [New Customers]
FROM Customers
GROUP...

• This reply was modified 2 years, 2 months ago by  Steve Jones - SSC Editor. Reason: code format

Any inputs please gurus? Thanks such as using temp table then convert them to col values etc?

Thanks

• This reply was modified 2 years, 4 months ago by  asita.

I think it using Pivot, with dynamic. Thanks

Any Advise? please

Week NewMembers FUMembersCounts EUMembersCount

Oct-03-2021 To Oct-09-2021 0 0 0

Sep-26-2021 To Oct-02-2021 0 0 0

Sep-19-2021 To Sep-25-2021 0 0 0

Sep-12-2021 To Sep-18-2021 0 0 0

Sep-05-2021 To Sep-11-2021 0 0...

Hi Jeff Good Morning,

Any advise please

Thank you,

asiti

Hi Jeff

tried below changing to week instead of MM, getting all zeros seems it has issue with join last but one line on filemonth. any advise please?

DECLARE @pStartMonth DATE

,@pEndMonth DATE

;

SELECT...

Sure Linden will try it. Thank you

Anyluck / Chance Jeff ? Please 🙂

Thanks

Thank you Much Jeff. I owe you a big party 🙂

Good Morning Jeff 🙂

Definitely owe you for this great help for sure will celebrate Jeff 🙂

i just put some sample so in a way can we aggregate to weekly rather...

Hi Jeff,

I tried with WK passing in the Date Add but due with function somehow it is all zeros 🙁

can you please let me know since it is only 5...

Thank you Jeff.

One last request on this.  so we have only 5 years worth of data altogether (Filedate column) from 2017 onwards.

so here how can I change months data to...

Agreed Jeff, Thank you very much for helping it out

only thing here i am doing is some conditions that i need to extend this. I am good so far

Thank you a...

Can you please assist with some way.

Thank you