Home Forums SQL Server 2008 T-SQL (SS2K8) help in designing table(saving multiple values for one PK value in one row) RE: help in designing table(saving multiple values for one PK value in one row)

  • One thing I would definitely suggest is collecting a list of common questions that you're going to ask of your database, and test your design by trying to answer the questions by writing SQL statements against your sample data. (I was taught to test with maybe 5 rows per table). The idea is to make sure your design is sound and you can get the answers you need. If you can't answer them by writing SQL statements, then your design is likely wrong.