Home Forums SQL Server 2014 Development - SQL Server 2014 how to update values based on column into multiple columns in another table RE: how to update values based on column into multiple columns in another table

  • July 31, 2015 at 12:08 pm

    #1816510

    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.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2