write a stored procedure to insert the results of the DMV into a table in your database and then call it from the command line?

Are you reporting against a live database or a read-only copy?

Huh? This has nothing to do with the problem.

execute a select statement with the same filter to make sure you don't get any false positives, and when you've fixed that part, use the filter/where clause in your update...

It should. It will update every record that would be selected by the filter, though. So you may update more records than you intended to.

What happens if you go into SSMS and attach? Right-click on the databases folder and choose Attach... then do you see your files when you browse?

Probably the easiest way to do this is to have an auxiliary Calendar table that you use to make this really easy. There are several articles here with examples...

If you can find the code from one of the sadly dead and gone Access <version> Developer's Handbook: DESKTOP, you might find the code for it. If I recall...

Okay, that's weird. Works if I create SQL for the query in Access then paste it into the Query window. Otherwise, doesn't seem to work. Maybe the...

Multi-valued fields are evil.

Break the multi-valued field into a separate table and use that.

Helpful explanation. Makes thing easy!

Note: I have a Report parameter that is of type Date (so when it runs you can pick a date from it...), it's called "prmOrderMonth"

This...

Jeff,

Okay, THANKS. Got part of it working... at least the linked server shows up... I can't query it, but I can see it. =) (About as much fun as...

Just wondering, where are the 64-bit ACE drivers available? I seem to have the 32-bit ones, and SQL Server is throwing a fit. (I suppose I could do an...

Here[/url]'s Jeff's article. Definitely worth a couple of reads.

Feel free to obscure any sensitive data... what is helpful is a representative structure of the data... and something we can...

CREATE TABLE scripts?

INSERT scripts?

can't fix what we can't see.