thank you

Yes, avg monthly cost, then display it month-by-month

Current table is something like

Task Cost Start End

1      100 1/1/07 4/1/07

2      200 3/1/07 7/10/07

I need

Task JanCost FebCost MarCost etc

1            33       33          33

2            ...

Thanks, that makes sense, but I don't understand how I will be able to identify which column got selected.

Found my own solution, SQL Server 2005 had been installed as the default (local) instance so I had to change my connection to point to the fully named instance for...

What do you need to do with the Access apps? Extract data from the tables, run existing action queries, run existing code, or something else. Are the access files mdbs...

It is my understanding that DTS packages from 2000 will not run on 2005. Is this correct?

What else does not run?

check out this article http://www.sqldts.com/default.aspx?204 and the DTSBackup 2000 app at the same site.

Thanks I am still reviewing all of the info from MS, but I guess what I am really after is some examples of things that we be able to easier...

Don't know if you can do this in SQL 2005, but you can do it in VS.Net if you create a Database project you can create any folder structure you...

to support web apps you will probably want to get the Processor license, the following is from http://www.microsoft.com/sql/howtobuy/processor.mspx

Under this structure, a customer acquires a separate Processor license for each...

I just flagged this article as a Dud before I read everyones comments in the forum. I agree this one should have never been published.

Thanks for the suggestion, however, it turns out he did not have SQL Server SP4 like the server does. After upgrading his client tools the problem was fixed. Hope this...

Beginning SQL Server 2000 Programming by Dewson from Wrox has 2 chapters (out of 20 total chapters) that are dedicated to Stored Procs.

The following is from Informit.com

Not sure about that, suggest you try the OWC newsgroup and/or look for the Little Black Book for Programming OWC, not sure if this is the exact title.

I am using the Office 2003 web components in a Windows Sharepoint Services site to drill through data provide from Stored procedures in my SQL 2000 db and it works...