Koen Verbeeck (7/2/2015)

---

Ha, I see you finally made your...

Won't be long before we hit 5,000 pages on this thread!

It seems it's morphed into a water-cooler chat over time.

You will get a better response to this question (ie, a working solution) if you post it as described in the first link in my signature.

SQLCJ (7/2/2015)

---

It works, Thank you Phil. But still it makes me wonder why did ordering DOJ in ascending order changed the output of the column there ? Can you please...

Show it where?

This works, though my understanding of exactly what the ORDER BY 'does' in an OVER clause is a bit hazy:

with CTE

as...

This is one of the few cases where dynamic SQL should be considered.

Take a look at this [/url]article on the subject, particularly the 'dynamic SQL' bit.

metroman17 (7/1/2015)

---

DECLARE @ServiceStatus TABLE

(ServerName varchar(128)

,ServiceName varchar(128)

,StatusOfService varchar(128)

,StatusAsOn datetime)

INSERT INTO @ServiceStatus (StatusOfService)

EXEC master..xp_servicecontrol 'QueryState', 'msdtc'

UPDATE @ServiceStatus

SET ServerName=cast(@@SERVERNAME as varchar(128))

,ServiceName='Microsoft Distributed Transaction Coordinator'

...

When I have had this problem in the past, it has usually been because there...

What is the datatype of the PK?

Are you certain that only one instance of the job can be running at any one time?

For someone with so many SSC points, I'm surprised that you don't know how to insert links.

The first link was the same as mine, and

here[/url] is...

There is a Stairway devoted to it here[/url].

I'm not saying that it will be easy, by the way. But you may find something useful in there in terms of being...

The only thing that comes to mind that might allow that is BIML.

SQL Search[/url] from Redgate will do most of this for you. No code needed and it's free.

Brandie Tarvin (6/25/2015)

---

I know that already.

What I want is to be able to upload a picture of an error BEFORE I start a post. Then I can just call it...