krunal pande

krunal pande

  • 1.9k
  • 91
  • 14.5k

How to update dynamic table with dynamic column i SQL server

Sep 13 2018 8:40 AM
How to update dynamic table with dynamic column in SQL server.1) I have one dynamic table And column2) I have one more table ##week with column Average 515 647 689Column name like 01_08_2018_wed,02_08_2018_thu,03_08_2018_fri,04_08_2018_sat,05_08_2018_sun etchingI need to update dynamic table every Saturday column With average column valueOutput like this04_08_2018_sat 11_08_2018_sat 18_08_2018 515 647 689Please provide the solution how to get this output.

Brought to you by:

Answers (1)