Hi,

Would the following not work:

SELECT

s.TaskID,

t.TaskName,

T.TimeStarted,

s.Action,

s.SourceHost As Source_File_Location,

s.DestFileName As Destination_FileName,

t.Success,

t.LastErrorText

FROM

Stats S

JOIN Taskruns T

ON S.TASKID = T.TASKID

WHERE Success not like 'No xfers'

AND Success like 'Failure'

AND Action not like 'Process'

AND convert(datetime,convert(varchar(12),T.TimeStarted)) =

(select convert(datetime,convert(varchar(12),getdate())))

ORDER BY T.TimeStarted DESC

this essentially puts the Timestarted and getdate in the same format, which although it inserts the time, makes it 00:00.000 on both sides of the clause.

Regards,

John