Naveen PK (7/31/2015)
Luis Cazares (7/31/2015)
I'm just wondering why would you need to update these columns as you shouldn't store values this way if you want a normalized table. And if this is for a report, the update seems an unnecessary step.This is for an existing report. I am re-writing a stored procedure that is used by multiple teams. So report format cannot be changed.
I understand that a report format can't be changed. However, I'm not sure if the update could be removed and the columns can be populated during the insert. I can't be certain about it without more information on the process, but it seems possible.