How to update dynamic table with dynamic column i SQL server
How to update dynamic table with dynamic column in SQL server.
1) I have one dynamic table
And column
2) I have one more table ##week with column
Average
515
647
689
Column name like
01_08_2018_wed,02_08_2018_thu,03_08_2018_fri,04_08_2018_sat,05_08_2018_sun etching
I need to update dynamic table every Saturday column
With average column value
Output like this
04_08_2018_sat 11_08_2018_sat 18_08_2018
515 647 689
Please provide the solution how to get this output.