That does get the dates correctly. But I need it in a cursor format so that it will spit out a results set with the dates as the first...

There as got to be an easier way. The entire procedure mathematically is currently working,except for producing too many rows of data. The cross tabbing, for the purpose...

I needed to loop through dates and just grab a sequence number each time from the tally table to run it against parameters in a stored procedure. I then...

Thanks

I explained what I was trying to accomplish in detail because it seems to be tricky to get it to work exactly right.

If I have:

OPEN CUR_DATES

FETCH NEXT FROM CUR_DATES INTO...

The application that reports run from is a Third party vendor. It is a Java application and it is configured for JDBC or JTDC version of JDBC. If...

Thanks for the help!

The select works to get me the counts. And the idea of the Tally table does make the selects more simplistic. I just have to...