Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dnf999
Constraint Violating Yak Guru
253 Posts |
 Posted - 2006-12-07 : 06:42:13
|
| Hi guys, I am generating new scripts for novice users of SQL to use and was wondering if anybody had an opinion on the best way of producing the tables for my team to work on.Steps:- Create table with Raw Supplier and address info- Clean Data- Add clean data to Raw Supplier Table with additional fields, i.e. Clean_add_1, Clean_add_2 OR- Create Clean_Supplier Table with only clean data & should they need the original Supplier table they can match back on Supplier_IDAny suggestions on which method to use and why? Also, when running queries would it be better to have all the data in one master table or in various tables and do joins.Thanks in advance. |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2006-12-07 : 10:30:56
|
| No replies in 4 hours on this forum generally means that your question is not clear.Jayto here knows when |
 |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2006-12-07 : 16:19:01
|
| Clean data means that the information is stored in only one place.And that you have the right constraints on the tables.Does that answer your question? |
|
|
|
|
|
|
Table layout dilemma....