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 |
|
subhaoviya
Posting Yak Master
135 Posts |
 Posted - 2009-10-30 : 00:58:13
|
i have table _A which records inserted Simultaneous, i may one by one or buck as 2,4 at a time. and i have 3 more tables A1, A2, A3. i move the records to a1, a2, a3 depends on flag entered in table _A.the records from a1 get processed in machine (m1.1 or m1.2, or m1.3) and after processing the flag want to be updated in table A1. like other ... A2 in (m2.1 or m2.2 or m2.3) and a3 in (m3.1 or m3.2 or m3.3).i dont want to delete the records from _A during moving the records to A1,A2 and A3, need that records for future reference.how to perform this actionsis it enough to process with insert triggers in tables?how to maintain the queue correctly in A1,a2,a3 table?, i want to move the records from a1 to any of machine(m1.1 or m1.2 or m1.3) after confirming that previous process gets completed. thankssubha |
|
|
subhaoviya
Posting Yak Master
135 Posts |
Posted - 2009-10-30 : 01:22:54
|
| i found the logic in database, not need for front end coding.thanks senthilsubha |
 |
|
|
senthil_nagore
Master Smack Fu Yak Hacker
1007 Posts |
Posted - 2009-10-30 : 01:24:01
|
quote:
Originally posted by subhaoviya
i found the logic in database, not need for front end coding.thanks senthilsubha
Fine  Senthil.C------------------------------------------------------[Microsoft][ODBC SQL Server Driver]Operation canceledhttp://senthilnagore.blogspot.com/ |
|
|
|
|
|
|
|
|
Queue maintaing in table?