removed to avoid confusion

Sorry about that. Didn't realize 🙁

Are the results hardcoded like that for specific CustomerCodes? I put my Customer data in a table with start and end dates. The code you specified is updating...

If you run this code manually, does it do what you expect it to do?

exec ril_actuals_exceeding_budget_mail

if not, can you provide the code for that?

what shows up in RIL_Mail_Execution_report values...

When you loose network connectivity, you won't be able to get to the Oracle DB to update it. You won't be able to get anywhere on the network. ...

From the little sampling of data you provided, it looks like the script is doing exactly what you want it to do. The first Select..Into clause is using the...

As long as you have access to the other databases, you can run

SELECT distinct o.id, s.Name as 'Procedure_Schema', o.name AS 'Procedure_Name' ,

...

try this

declare @a TABLE (

AppointmentID int IDENTITY(1,1) NOT NULL,

ClientNumber int NULL,

...

Try using sys.schemas

SELECT distinct o.id, s.Name as 'Procedure_Schema', o.name AS 'Procedure_Name' ,

ss.Name as 'Table_Name', oo.name AS 'Table_Name', d.depid

FROM sysdepends d

inner join sysobjects o

on...

You'll have to use dynamic SQL. You can read information_Schema.columns for the table_name to get the columns. Then you can dynamically build the select syntax. Be careful...

What are you trying to do? Your last OpenXML statement returns data. What are the expected results?

take a look at msdb.dbo.backupset

It is running the procedure from start to end. The FMTOnly value is set to OFF by default. So your code will run from start to finish. ...

I agree with Eugene. If we can get a sense of the whole picture, we would have a better change of providing a more efficient set-based solution. What...

There's a couple of things wrong with this.

First is when setting the database name variable, it will error out if more than one is found.

Second, you...