Where you have two events with the same CompletedDate, how do you determine which one comes first?

John

You've been around long enough to know that you haven't provided nearly enough information.  What does the job do?  What makes you think it's hung?  How long does it normally...

SUM(TCost + OffCost) OVER (PARTITION BY [Dept#])

John

You mean from SELECT @retval?  It's because you have no @retval in your code.  I would remove those second and third parameters - they don't serve any useful purpose.

Put an N before the second parameter of sp_executesql.

John

Yes, it'll only return jobs that are scheduled.  Change the INNER JOIN between sysjobs and sysjobschedules to a LEFT JOIN to see all jobs.

John

Have you considered Reporting Services?  One report can use multiple sources, and you can create a subscription to send it out by e-mail.

John

You haven't posted all of your code, because you'd get an error that you haven't declared @SourceDBName with what you have posted.  Once you've fixed that, put a PRINT...

You can use sqlcmd or Powershell, or you can register the instances in their own group and connect to them all at the same time to run the query.  I'm...

Perhaps your statistics are out of date and so you're getting an inappropriate memory grant, causing spillage to tempdb?

John

I think he wants all combinations of one word from each group of synonyms.  The groups are (Employment, Job, Profession, Vocation), (Insurance), (Online, Electronic) and (Application).  I got close, but...

Lorna

This will reduce the number of CASE expressions.  Whether it's actually simpler is for you to decide!

WITH RemoveZeros AS (
    SELECT
        CASE ExchangeRate
            WHEN...

Yes, I would say about the size of the data that's being deleted.  But try it for yourself on a system that doesn't have anything else happening on it, and...

Well, something's changed.  Maybe somebody made an update to the job?  Or perhaps the job code contains some data-dependent conditional logic such that the requirement to use SQL Native Client...

If you want to subtract a value from a previous row, use the LAG function.

John