sql result:

startdate enddate price
2004-1-2 2004-1-4 677
2004-1-5 2004-1-8 900
2004-1-9 2004-1-12 2000


i want display in page this format:
2004-1-2 2004-1-3 2004-1-4 2004-1-5 ... 2004-1-12
677 677 677 900 2000

how can i write store procedure

This post is almost the same as the one you posted at Dynamic table

If there are two fields in the record set, the code is

<table>
<%dim row1 : row1="<tr>"%>
<%dim row2 : row2="<tr>"%>
<%for not rs.eof then%>
<%row1 = row1 & "<td>" & rs("field1") & "</td>"%>
<%row2 = row2 & "<td>" & rs("field2") & "</td>"%>
<%next%>
<%row1 = row1 & "</tr>"%>
<%row2 = row2 & "</tr>"%>
</table>