Hi,

I want to eliminate all nulls average by week and display like this. I know how to do this in manual pivot but not as dynamic pivot.

Regards
Pawel

Great you are an legend 🙂
Thanks a lot.

I tried to run this qry from link from Mike: 

January 18, 2019 at 7:11 am

#2019360

HI Guys,

Thanks for your replay, but I think I need to start from the beginning and populate all information that are need it.

So based on Mike's...

Thanks Jonathan for you replay.
Unfortunately this solution is not working too.
"Msg 156, Level 15, State 1, Line 11
Incorrect syntax near the keyword 'CONVERT'."

I will...

Hi MIke01

Thanks for your replay and link how I should place questions with data attached.
I am new to forum and SQL world 🙂

I tried Round...