|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Using one temp table with another
This is probably easy but I'm stumped.
I have a lengthy query in a sp that produces into a temporary table a list of rental orders for a particular product needed for a specified time window of usually a few weeks (eg 11/10/2003 to 2/11/2004) eg Order no date of order item no qty ordered start rent end rent 1223 11/2/2003 A-1001 10 11/10/2003 12/28/2003 1257 12/5/2003 A-1001 5 12/24/2003 12/30/2003 1288 1/8/2004 A-1001 3 1/21/2004 2/11/2004 etc. In the same sp, I want to build a table by day from the paramaterized start and end date of the window which holds the total quantity needed each day for each specific item, eg how many A-1001s are needed on each day date qty 11/10/2003 10 11/11/2003 10 11/12/2003 10 * * 12/24/2003 15 * 2/11/2003 3 Any suggestions apprecited! |
![]() |
| Viewing: ASP Free Forums > Database > SQL Development > Using one temp table with another |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|