Is this a direct SQL to SQL datapump? If so, do you have any indexes on the Archive table? If not try adding a clustered index, there has been documented...

Egads

Have you not heard of stored procedures!!

Do a Response.Write before the execute to get the actual sql...

Send an email to philcart@gmail.com and I'll send some screenshots.

The rdl files are the report definition and are only using in designing the report. Once the report has been designed it's "compiled" and stored in the ReportServer database. at...

Is your footer table summarising information that is in the main table? If so, can't you place the summary info in the footer of the main table?

Well I must have a special server  

I use this exact routine in my custom log shipping routine that runs every 5 minutes...

That's still pretty vague.

Is this date stored somewhere and you want to change it after you've performed the processing??

You could perform the same function without using OSQL and xp_cmdshell.

CREATE PROCEDURE dbo.usp_TestLinkedServer
 @SrvrNm nvarchar(128)
AS
BEGIN
 SET NOCOUNT ON

 DECLARE @sql nvarchar(500)

 SET @sql = N'SELECT TOP 1 [spid] FROM ' +...

Can you explain the business rules a bit more? ie: what has to happen if the current date is 04/20/05 ??

Please don't cross post.

See my reply http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=172020

There are various ways to do this that involve invoking COM objects and the like, but that gets a little too complicated for my liking.

What I've found to be best...

Interestingly the sp_who2 code contains this comment in the dynamic SQL,

      -- (Seems always auto sorted.)   order by spid_sort

What collation are you using? The spid field is converted to a...

You put it in the document map label. This is a standard thing for hyperlinks. You can also use _self, _top, _parent, etc...

From Books Online,

"Advanced Textbox Properties (Navigation Tab)

Use...

How about using the SQL Health and History Tool to track server and database info.

http://www.microsoft.com/downloads/details.aspx?FamilyID=eedd10d6-75f7-4763-86de-d2347b8b5f89&displaylang=en

One thing that I've found handy as part of the checking routine. I run SQL locally on my workstation and all the other SQL Servers forward events to it. Makes checking...