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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-09-16 : 12:30:25
|
Dave writes "I sure could use your help. My situation is that I have designed a SQL Server 7 with the tables normalized out. I am trying to integrate it with an old "flat table" database, for the purpose of keeping the category and subcategory data in synch between the two.
Can you help me with the trigger sql to handle insert/updates from the flat table DB to my DB?
The flat table has the following data that needs to be monitored:
"flat table DB"
table name- ypCategories
fields to monitor-
category varchar(255), subcategory varchar(255)
new DB to keep category/subcategory data in synch
table names-
tblProductCategory, tblProductSubCategory
tblProductCategory:
PK field- lCategoryID int
data column- sCategoryName char(30)
tblProductSubcategory:
PK field- lSubCategoryID int
data column- sSubCategoryName char(30)
FK field(tblProductCategory)- lCategoryID int
Trigger requirements:
1) fire anytime that a new cate
|
|
|
|
|
|
Insert/Update Trigger problem