• A couple easy suggestions. Your name of ID is inadequate as Lowell pointed out previously. Your columns don't make any sense to me. There is one thing that will help you immensely as you are designing this. A column name should change its name based on the table it is in. You seem to have ID as the primary key in every table. But when that is referenced as a foreign key in another table the name changes (BayID, DoorID, ElevationID). Those names should be the same in EVERY table.

    I don't understand what you are doing here, so I can't really offer much advice. Well I would strongly advise you to get a book or two on how to structure data.

    I am assuming by your name that you are building rooms/buildings? What is Finish? Is that finish as in Oak, Stainless, etc??? What does elevation have to do with Finish?

    I get that you are just building this but your question is so incredibly vague I don't even know where to start. My fear is that you are WAY over-thinking this. If you can explain what you are trying to do I can try to help guide you a bit.

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/