dwain.c (12/13/2013)
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 yI 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 +1 +1
+1 also. In the original design, you'd need to keep adding columns forever. Properly structuring it will help you so very much in the end. The pain you'll avoid down the line by restructuring it now will be very much worth the effort.