Does Cross Apply work in SQL Server 2005? I'm getting -Incorrect syntax near the keyword 'VALUES'.

Also, making it slightly more challenging - two more fields, LExecuted, and LB_Submitted. If LExecuted is not zero length and not null I need that date. If it is null or zls try LB_Submitted, if also null or zls I need the max date of the three original fields...

DECLARE @T TABLE (ID INT PRIMARY KEY, SentDate VARCHAR(10), ReceivedDate VARCHAR(10), CreatedDate VARCHAR(10), LB_Submitted VARCHAR(10), LExecuted VARCHAR(10))

INSERT INTO @T VALUES (1, NULL, '2-11-2012', NULL, NULL, NULL)

INSERT INTO @T VALUES (2, '22-10-2012', NULL, '2-12-2012', '', NULL)

INSERT INTO @T VALUES (3, '8-8-2012', NULL, '', NULL, NULL)

INSERT INTO @T VALUES (4, NULL, '', '25-12-2012', '', NULL)

INSERT INTO @T VALUES (5, '7-11-2012', '1-8-2012','5-1-2012', NULL, NULL)

INSERT INTO @T VALUES (6, NULL, NULL, NULL, NULL, '6-30-2012')

INSERT INTO @T VALUES (7, NULL, '', NULL, '4-3-2012', '')