Example from 'event' table:

IDSource_IDEventType_ID Use_ID Period

34022 10 ...

Thanks all.

that did the trick excellent!

Thank you

Thank you for these replys.

I think the nearest that came to what I am after was:

SELECT DISTINCT CONVERT(datetime, CONVERT(char(8),LoginTime,112), 112) AS [date], [Application], [SystemUser]

FROM DW.ServerLogonHistory

ORDER BY CONVERT(datetime, CONVERT(char(8),LoginTime,112), 112)

which...