Originally posted by dbasupuser
and don't want to use pro-c.
Ugh - why in the world would you?

So, how many weeks do you have to display?

Do you have a table that translates dates to weeks?

What is the ID that you plan to display for each week, since there is an ID for every day?

When you say 'output table', do you simply mean resultset or do you have an actual table?

Provide as many details as possible, please.

- Chris