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 |
|
jrosser
Starting Member
14 Posts |
 Posted - 2012-06-19 : 16:56:23
|
| I have a SP that takes 4 parameters and returns a customers pricing.Customer, Branch, item and qty.The SP returns a bunch of fields but I only need 1 field which is in the 4th position.I want to create a SP that will find out how many items exist in a specific branch, and then loop through passing the Customer, Branch, item and qty (always 1)Then write those results to TableSo I would like to write the Customer, Branch, Item and the price which is retreived from the SP.is something like this possible?Thank youJeremy Rosser |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-06-19 : 18:35:58
|
| where will you get price from ? is it present in same table or in another table?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Passing parameters to a SP through a loop