Adam

A SQL Agent job is intended to run unattended, so you can't pass parameters to it. You could create a table with date column(s) that contain the dates to...

There's all sorts of things. You're trying to use a stored procedure (OH_Message) as a function. You're trying to assign a value to a variable (@status) without a...

Brandie

Is it a witness you're looking for?

John

WITH Starts AS (

SELECT

CUSTOMERID

,TIER

,STARTDATE

,RECORDSTATUS

FROM

TEMPHISTORY

WHERE

RECORDSTATUS = 1

)

, Ends AS (

SELECT

CUSTOMERID

,TIER

,STARTDATE ENDDATE

,RECORDSTATUS

FROM

TEMPHISTORY

WHERE

RECORDSTATUS = 0

)

SELECT

s.CUSTOMERID

,s.TIER

,s.STARTDATE

,DATEADD(dd,-1,e.ENDDATE) ENDDATE

FROM

Starts s

LEFT JOIN

Ends e

ON

s.CUSTOMERID = e.CUSTOMERID AND s.TIER = e.TIER

AND

e.ENDDATE > s.STARTDATE

John

Edit: - this may not be the...

No, COPY_ONLY only breaks the differential "chain".

Managers and users shouldn't need to worry about warmth and fuzziness - that's why they pay you to administer their databases. Although if...

You could deny the application account whatever permission it needs to run backups, assuming that doesn't break anything else.

John

Use ROW_NUMBER() over that first column, and just select the one where the row number is 1.

John

What was that - sample data, expected results, or actual results?

Anway, if I understand correctly, your question is why the SELECT statement returns more than one row? The answer...

Chris

Please will you post the whole query, along with some sample data? What results do you get, and what results are you expecting?

Thanks

John

I can't see anything there that would obviously run differently under different settings. What I advise you to do is to capture each event with a trace, and capture...

There are some things you can check. Do any batch processes, backups or database maintenance run during the slow period? You can query your plan cache for the...

Be careful when you do this, because if someone has already compensated for the collation difference by putting COLLATE Latin1_General_CI_AS clauses throughout the code, then things may start breaking.

John

Andre 425568 (8/12/2014)

---

I will so what the settings are in SSMS and SSIS, but I do not think that is the issue, the normal queries, that also run from a...

Yes, that'll work if you want to run it interactively. If you want to automate it, you'll need to centralise using SSIS or similar.

John

For SSMS, go to Tools -> Options -> Query Execution -> SQL Server -> Advanced. For SSIS, it depends on the properties of the network library you're using to connect...