Here is my current scenario.
SELECT S.MSGTEXT FROM [dbo].[Syslogd] S INNER JOIN (SELECT T.[MsgDate] AS 'MSGDATE' ,MAX(L.[MsgTime]) AS 'MSGTIME' FROM [KiwiSysLog].[dbo].[Syslogd] L INNER JOIN (SELECT MAX(MSGDATE) AS 'MSGDATE' FROM [dbo].[Syslogd]) T ON L.MsgDate = T.MSGDATE GROUP BY T.MSGDATE) DT ON S.MsgDate = DT.MSGDATE AND S.MsgTime = DT.MSGTIME
Results in Microsoft SQL Server Management Studio Express:
I appreciate the help.