You cannot EXEC stored-procedures HOWEVER you can have user-defined functions in-line.  You may want to research UDFs and see if they can accomplush your desired results.

Probably another VERY GOOD reason that I forget about COALESCE

Thank you as always for keeping me from hurting myself

there are various different ways of resolving this.  Create an Excel file with unique name everytime, Have a template Excel file that you populate and save as a different name,...

Did abc's password expire/change?  Is the account locked?

How bout granting access to a scheduler task on the server that the user can modfiy the schedule?  This way the job will be activated from the server and the...

I honestly don't know Frank.  I know that I generally forget about COALESCE until I read about it here.  Figured the CASE and COALESCE in certain instances go together. 

How bout

CASE Col1 = 'HHHH' THEN Col2 ELSE Col1 END AS SReturn ???

You may want to review COALESCE as well..

Can you have this DTS package scheduled?  Is it possible that you have a web server and can perform this from the web?

If the user is supposed to run the...

Something like this might help you:

UPDATE B SET ItemCount = A.RecCnt

FROM tableA A

  INNER JOIN (SELECT DespatchNoteNumber, COUNT(*) RecCnt

    GROUP BY DespatchNoteNumber) B

ON A.DespatchNoteNumber = B.DespatchNoteNumber

Probably.  Only because VS .NET 2K3 was released prior to 2K5 and all of the different functionality would not be ready for release yet

Are Named Pipes and TCP/IP enabled on the second set of servers??

You might be able to use this and build a function out of it.  This will remove anything that is not from a-Z.

SET NOCOUNT ON

DECLARE @String AS VARCHAR(255)

DECLARE @IntStr AS VARCHAR(255)

DECLARE...

Another option is to have a ModifiedDtTm column with the Date/Time of when the records have been modified and then all you would have to do is SELECT [columns here]...

You will need to have the structure of your query go:

FROM then WHERE then GROUP BY then HAVING and finally ORDER BY

The GROUP BY is required for the COUNT()...

Why not simply

UPDATE table SET Column  = REPLACE(Column, 'mkpdc', 'SRV01')