How about via SSMS, by right-clicking on the job and selecting Stop Job ?

For one thing, updating the records one at a time via the For Each Loop container is a seriously bad way to approach an update of any sizable number of...

Just thought I'd toss in a CLUSTERED INDEX on the data, and see what the following looked like on execution plan:

--===== If it exists, drop the test table to make...

You're welcome.

curious_sqldba (11/19/2015)

---

sgmunson (11/19/2015)

---

So.... what makes you doubt the accruacy? Be aware that if anyone with the necessary permissions manages to delete any of the job history, then yes,...

So.... what makes you doubt the accruacy? Be aware that if anyone with the necessary permissions manages to delete any of the job history, then yes, it could...

Try this and see what you get:

SELECT

t00.ScenarioID,

t01.[GROUP],

'' AS GroupName,

t01.companygroupaccount,

t01.accountnum,

t01.accountname,

t00.ActualValue + t00.Forecast AS Forecast,

0 AS ForecastPercentage,

t00.BudgetValue AS Budget,

0 AS BudgetPercentage,

t00.BudgetValue - (t00.ActualValue + t00.Forecast) AS Variance,

0 AS VariancePercentage

FROM (

SELECT ScenarioID,

AnualSalary,

ISNULL(EndSalary, 0)...

Ummm... answering your questions requires understanding exactly what such a dynamic query is supposed to accomplish, and I don't see that stated anywhere in your post. Also, by...

You're probably going to want to make a permanent table out of this, if performance doesn't suffer so badly that you have a problem on that front. And...

There is no direct or obvious methodology for that kind of thing. You need to derive that data in the query that is used to create your data source....

Yes, it's do-able, but there are a number of questions that immediately come to mind... First, you need a simple calendar table, which you can create in a CTE....

Turned out I was misinterpreting the values from sys.database_files. The max_size value coming back was 256 MB, but as that value represents the number of 8K pages, or...

Are you talking about changes to values, or changes made to the schema that affect the primary key field? There is no inherent provision for tracking either one,...

With that thought in mind, perhaps something like: LTRIM(RTRIM(field1)) = RIGHT(field2, 6) ?

e.g.

UPDATE TT

SET TT.Vinnumber = RRS.Vin

FROM dbo.R_ResrvStock AS RRS

INNER JOIN Txt_Temp...

This one is a bit of a sticky wicket, in that I have no idea what you are trying to accomplish. I'm guessing that English is not your...