Viewing 4 posts - 1 through 4 (of 4 total)
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.
August 26, 2016 at 11:48 am
If the above isn't possible you can always treat your current query as a subquery and do
select distinct * from (subquery) A
August 26, 2016 at 11:39 am
Any way to get this to work with a report in a load balanced sharepoint system instead of SSRS
June 30, 2016 at 12:20 pm
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...
January 26, 2016 at 12:04 pm