A real Challenge

[wangyc77]

I would like to make the following data in my database

SID fromDate ToDate Price
1 2006/01/01 2006/1/3 100
1 2006/1/4 2006/1/5 150

into

SID Adate Price
1 2006/1/2 100
1 2006/1/3 100
1 2006/1/4 150

When I specify a range
Please help~~!!

 

[r937]

what happened to 2006/01/01 and 2006/1/5? why did they get dropped?

what are you trying to do?

r937.com | rudy.ca

 

[JarlH]

You'll need calendar help table containing all dates.

Then you can do something like

SELECT sid, Adate, price
FROM calendartable, currenttable
WHERE Adate >= fromDate
AND Adata <= toDate