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 |
|
sqldoubts1
Starting Member
1 Post |
 Posted - 2009-01-19 : 09:53:43
|
| Hi All,I have two tables such as ams_nsa and ams_nsa_type.The tables are used for Leave management application so dates will be inserted in both the tables thru the application.I have written code such as when i apply leave it will get added in first table and copied to second table.when i try to apply leave,it gets successfully added in first table(ams_nsa),it is also getting copied to second table(ams_nsa_type) but the issue here is ,when i apply leave for dates 1 t0 8 it is getting added only in first table not in second table.For all the other dates (9 to 31) it is updated in both the tables. I have checked the data type ,it is same in both the tables.Can anyone help me on this,why it is not getting updated for date 1 to 8 on second table? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-19 : 09:55:42
|
| can you post code for insertion? without seeing that we cant suggest much.also is there any trigger on table? |
 |
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2009-01-19 : 09:56:14
|
| Can you show the code you're running? DDL and data samples would be nice as well.Terry-- Procrastinate now! |
|
|
|
karthik_padbanaban
Constraint Violating Yak Guru
263 Posts |
Posted - 2009-01-19 : 09:57:28
|
| Can you show the code.Karthik |
|
|
|
|
|
|
Not getting copied in DB