I'd dump both tables into temp tables, and cast your time fields as smalldatetime (which doesnt contain the centiseconds) while performing the dump. Join the temp tables.

If the above isn't possible you can always treat your current query as a subquery and do

select distinct * from (subquery) A

Any way to get this to work with a report in a load balanced sharepoint system instead of SSRS

why are you casting them as int? int stands for integer meaning the conversion truncates your decimal places. just get rid of the int() then format the text box where...