No, I'm not forgetting, I'm deliberately avoiding that. 😛

From a performance standpoint, it...

Style 109 is 'mon dd yyyy hh:mi:ss:mmmAM', for instance 'Oct 13 2011 2:57:12:350PM'.

AS you can see, this format cannot be sorted...

Darn! I guess you're out of luck.

I tried in many ways, but I think that this particular requirement can't be implemented with an indexed view.

Some restrictions apply, and one of...

Lynn Pettis (10/13/2011)

---

I don't see a distinct in the original query.

Sorting on starttime will give the same results...

Richard Warr (10/13/2011)

---

Alternatively, you could use ROW_NUMBER to accomplish this:

SELECT VulnID, Host, SCANCOMPLETETIME FROM (

SELECT VulnID, Host, SCANCOMPLETETIME,

ROW_NUMBER() OVER (PARTITION BY Host, VulnID ORDER BY SCANCOMPLETETIME DESC) rw FROM...

Prepare a list of disabled users and add it to this code.

USE master;

GO

DECLARE @DisabledUsers TABLE (

LoginName nvarchar(128)

)

INSERT INTO @DisabledUsers VALUES ('Tom')

INSERT INTO @DisabledUsers VALUES ('[MyDomain\Harry]')

INSERT...

You can use an INDEXED VIEW and a UNIQUE constraint.

See my blog here[/url].

Phil Parkin (10/13/2011)

---

I suspect (just a wild guess) that the query contains DISTINCT in the select list and, since the OP is selecting the converted date, can only ORDER BY...

I'm afraid I ended up overcomplicating the original problem.

Anyway, here's my solution:

-- SETUP: Create master table (sentences)

DECLARE @ThisTable TABLE (

id int

)

-- Create detail table (sentences broken in rows, Latin, English,...

I suspect (just a wild guess) that the query contains DISTINCT in the select list and, since the OP is...

You just need to reference the main query in the subquery. Something like this:

DECLARE @VULNS_VIEW TABLE (

VulnID int,

HOST varchar(10),

SCANCOMPLETETIME datetime

)

INSERT INTO @VULNS_VIEW

...

Is your SSMS patched to the latest service pack?

I've seen some bugs in the RTM version regarding SQL Agent Jobs.

You're welcome, glad I could help.

Lynn Pettis (10/12/2011)

---

To proudly go where few have gone! Just how many people have gone into space? What an honor it would be to be a part of...

I'm scared to death whenever I fly with...