Home Forums SQL Server 2008 T-SQL (SS2K8) query Help RE: query Help

  • December 13, 2013 at 6:27 am

    #1673228

    pietlinden (12/12/2013)

    Your table is really structured like that? What happens if you get more software packages? Does the table structure change? IF y

    I think storing information using this structure/pattern is bound to fail. I worked on data like this every day for six months, and it was a nightmare.

    Why not use a different table design?

    Server===(1,M)---InstalledSoftware---(M,1)---SoftwareVersion---(M,1)---SoftwareTitle

    then you can add servers, versions, titles all you want. If you want a crosstab, use SSRS or do a PIVOT.

    +1. Normalise this mess.

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden