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 |
|
edb2003
Yak Posting Veteran
66 Posts |
 Posted - 2003-08-15 : 17:09:59
|
| Thank you for your input Tara and Chad,I have played with inner joins with a field driven application but not a record driven application. Here is what I have.A masterDatabase with 16 tables outside of it. Each table has an ID linked to the Master Database by ID. The tables outside of the master database have the following information (Based on 1 of 16 tables)TableName UserDesignView user_id user_pwd / - Unique information to each of 16 tablesentered_by |entered_date |updated_by | - Log Tracking fields wrapped into eachupdated_date | Table to track changesWhen I insert new information to a flat table, it is Select Insert * From [My Table]Add rs.newThe above select statement would not work in my .net app but probably a select Insert to a stored procedure. If so, and based on my ID driven tables, how should I approach this?I have a book on Transact SQL by William C. Amo but it does not show many examples. I will look at Northwind this weekend unless I have a better record driven example to work with.Thanks bunches for your help :)Ed |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-15 : 17:13:25
|
| You don't need two threads open for this:[url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=28522[/url]Tara |
 |
|
|
|
|
|
Record Driven Data - not flat driven (ERD)