krunal pande

krunal pande

  • NA
  • 101
  • 28k

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

Answers (1)