What's wrong with the one you posted - performance, wrong results, error messages?  Will this one not work just as well?
Select CustomerNumber, count(CustomerNumber) as Count
From SalesData

Somebody or something has stopped the jobs, either through the GUI or with an sp_stop_job command.  Did this happen just once, or does it happen regularly?

John

Try this.  It's not tested because you didn't supply DDL and INSERT statements.  What do you want to happen if there's more than one xyz?
WITH Ordered AS...

In the first error, you're missing a backslash from your path.  What it's looking for is a file called "sftpto Televox.bat".  Do you have Integration Services installed on the server?...

Is the batch file in the root of the G drive?  Please try moving it to a subfolder - I've seen strange things happen when trying to programatically access files...

Join sys.database_principals to sys.server_principals on sid=sid.

John

Chances are you're going to be supporting it, so you need to document and understand it.  The COALESCE function takes the value of EndedAt, and if it's NULL, changes it...

I'd go into this with a more open mind.  If it's a data load from another server, it doesn't have to be disk IO - it could be network latency,...

Start with a calendar table and then do something like this:

SELECT
    c.MyDate
,   t.ProductType
,   COUNT(t.ProductType)
FROM Calendar c
LEFT JOIN ContractTable t

Albert

There are several different settings that can very depending on which user runs the query, or what provider you use to connect to the database and hence what's...

WITH NowandNext AS (
    SELECT
        H_SystemCustomer_Seq_ID
    ,   RateDate
    ,   Grade
    ,   LAG(RateDate) OVER (ORDER BY RateDate) AS OldDate
    ,   LAG(Grade) OVER (ORDER BY RateDate)...

Just because, really.  You can't restore master unless you're in single user mode.  That's how the product works.  Probably is something to do with master always being in use, though.

Vivek

Restoring the master database is one.

John