Thanks! I wasn't aware of STUFF

I added the exec since I am actually working in a 2000 environment. I posted in this forum since I was also able to generate my error in a 2008...

Thanks you all once again. This is resolved.

>>It seems odd, on the face of it,

Yes its true, I'm somewhat in explaratory mode here...

If the predominant advantage of using TIME is the smaller storage size and the precision...

I believe you need dynamic SQL for this.

Search this site or the web using these keywords:

dynamic sql pivot

dynamic sql crosstab

No worries.Your generous and informative posts have benefited my humble self many, many times.

I have xp_cmdshell available on this server and I'll explore vbscript. I'll post back when I have...

Am I misunderstanding the suggestion?

http://technet.microsoft.com/en-us/library/ms186865.aspx

MIRROR TO <backup_device> [ ,...n ]

Specifies a set of up to three secondary backup devices, each of which will mirror the backups devices specified...

I think MIRROR TO is only for Enterprise Edition. I am on Standard. A lightweight vb script seems like an option I'll explore that.

My source is going to have three days, my new destination folder should just have the latest full and subsequent trans.

CASE isn't available in Access you would need to use iif.

>>Is the overhead of creating the replica greater than the benefit achieved or would it be more efficient to increase the resources of the existing SQL server.

You would have to...

If you put a PRINT @sql command within your cursor are you getting the expected results?

Nice. thank you, that'll work!

My apologies but I have to report back that I tried neither the pie chart or the image suggestions. I don't see any reason the Insert>Image wouldn't work.

I convinced the...

Here are some options. All should use a calendar table.

1-Create a stored procedure that does the date logic and then conditionally executes a package via DTEXEC. Run it every day....