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 |
|
zakyfirdaus
Starting Member
6 Posts |
 Posted - 2005-09-12 : 23:22:55
|
| Hai ALL,i have 2 table, first table is CUSTOMER table that have 2 field (id_cust,id_support)second table is SUPPORT table that have 3 field (id_support, support_name,role)CUSTOMER TABLEid_cust id_support3301 03302 03303 03304 03305 03306 0SUPPORT TABLEid_support support_name role011 john 2012 smith 3013 rina 4 i wanna insert data from SUPPORT TABLE (id_support) to CUSTOMER TABLE (id_support) incrementally based on sum of id_supportand i wanna use a stored procedure to execute that..n the result that i want is :CUSTOMER TABLEid_cust id_support3301 0113302 0123303 0133304 0113305 0123306 013SOMEBODY PLEASE HELP ME....THANX BEFORE...REGARD ZAC |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-09-13 : 11:35:59
|
| http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxMeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
|
|
|
HOW 2 INSERT DATA INCREMENT WITH STORED PROCEDURE?