Home Forums SQL Server 2008 T-SQL (SS2K8) Working with a Very Poorly Designed Database RE: Working with a Very Poorly Designed Database

  • October 25, 2013 at 6:07 pm

    #1661768

    lnardozi 61862 (10/25/2013)

    Just a thought - category1 thru category5 could just be computed fields. You already have all the information you need in Score.

    I'm sure that Andrew can't change the table structure. If that would be possible, five category columns are not ideal. The best option would be to have a Categories table and a category column in the MemberScore table to reference the Categories table (a.k.a. a Foreign Key).

    I'm glad I could help, have a good weekend you too.

    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