Home » Other » Test » testing
testing [message #139588] Wed, 28 September 2005 14:14 Go to next message
Ako1
Messages: 1
Registered: September 2005
Location: Texas (US)
Junior Member
testing!!!
Re: testing [message #182715 is a reply to message #139588] Mon, 17 July 2006 14:51 Go to previous messageGo to next message
shumeric
Messages: 4
Registered: July 2006
Location: Chicago
Junior Member
SELECT rest_key,wrin,proposalamount,storeamount,orderdate 

           FROM (SELECT /*+ INDEX(w) */ 

               	        'R'||LPAD(siteid,5,'0') rest_key, 

        LPAD(wrinbase,6,'0')||LPAD(wrinsuffix,3,'0') wrin, 

orderdate,
SUM(proposalamount) proposalamount,
SUM(storeamount) storeamount
FROM us_orderproposal_state@weblog
WHERE orderdate < TRUNC(SYSDATE) +1
AND orderdate > TRUNC(SYSDATE) - p_weblog_days_back
GROUP BY 'R'||LPAD(siteid,5,'0'),
LPAD(wrinbase,6,'0')||LPAD(wrinsuffix,3,'0'),orderdate);
Re: testing [message #182716 is a reply to message #139588] Mon, 17 July 2006 14:52 Go to previous message
shumeric
Messages: 4
Registered: July 2006
Location: Chicago
Junior Member
SELECT rest_key,wrin,proposalamount,storeamount,orderdate
           FROM (SELECT /*+ INDEX(w) */ 
               	        'R'||LPAD(siteid,5,'0') rest_key,
               		    LPAD(wrinbase,6,'0')||LPAD(wrinsuffix,3,'0') wrin,
                        orderdate,
               		    SUM(proposalamount) proposalamount,
               		    SUM(storeamount) storeamount
               	 FROM us_orderproposal_state@weblog
           WHERE orderdate < TRUNC(SYSDATE) +1 
           AND   orderdate > TRUNC(SYSDATE) - p_weblog_days_back
           GROUP BY 'R'||LPAD(siteid,5,'0'),
               		LPAD(wrinbase,6,'0')||LPAD(wrinsuffix,3,'0'),orderdate);
Previous Topic: test post ...
Next Topic: test
Goto Forum:
  


Current Time: Tue Jan 19 00:32:22 CST 2021