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 |
|
Sagini
Starting Member
1 Post |
 Posted - 2005-02-23 : 13:55:54
|
| Hi there. I am pretty new to SQL and here is the problem that I have run into. I have a table mix_results, which was created without a id columns. Everytime a new row is inserted into this table I want to update the table test_results with by populating it with last 25 rows (it is sorted by date) from mix_results. I know this has to be done using triggers ... I would appreciate it someone can give me a good start. Thank you |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-02-23 : 16:48:35
|
| Please post the DDL of the mix_results and test_results tables. (you only have to include relevant columns)Sample data for the tables before and after the insert would be helpful as well.The "without a id columns" should not be a problem, as long as the tables have some key on them.When a column is inserted into mix_results, do you want to generate 25 new records in the test_results table ?rockmoose |
 |
|
|
|
|
|
Trigger to check one table and update another