Ozzmodiar (6/2/2015)

---

I see you have a perfectly valid solution, so I won't bother typing it all up unless you're interested.

There is a very elegant solution to this problem using the...

Thanks Phil, that was very helpful!

This is the table script and some sample data:

USE [tempdb]

GO

--DROP table [dbo].[status]

CREATE TABLE [dbo].[status](

[server] [nvarchar](50) NULL,

[component] [nvarchar](50) NULL,

[status] [nvarchar](50) NULL,

[date] [datetime] NULL

) ON [PRIMARY]

GO

INSERT INTO [dbo].[status] VALUES (N'servA', N'comp1',...