thanks again

One more question if I may? If I needed other data, say a date/time stamp and a some resolution codes, from the same table returned with the query, what would...

Thanks for the help, I'll give this a try.

do you know anyone who could do some freelance work to help me create a report using SQL 2000 Reporting Services? I know all the SQL to generate the results...

thanks

Thanks. I'm still fumbling with this but you've been a great help.

David

Thanks again, I created the DTS but can't seem to find where to go to edit the SQL that I created in the DTS "editor"?

David

This seems to work. What are the advantages of DTS or running a scheduled job?

Thanks for the suggestion!

I'm a newbie to SQL relative to most of the folks on the board here and have zero experience with DTS although I will give it a try.

sorry realized I can easily answer my own question on that second part.

Thanks, I'll try this. Do you know if the Query Analyzer settings are "fixed" across different instances? In other words if I normally leave two instances open, will the settings...

How do you get to the First Day of Prior Month?

I'm trying to use an agent to automate a monthly report that will, without having to input a date, render...

Thanks to all...

I have a non complex select query (select * from TABLE between date range) that pulls data from a table. I save that to a csv file thru Query analyzer...

When you say presentation layer, is there any way to do that with the csv file created from the query or does that have to be done with SQL reporting...