calvo (5/20/2010)
Select convert(varchar(2),(sum(Datediff(HOUR, clkin, clkout))))+ ':'
+ convert(varchar(2),sum(Datediff(MINUTE, clkin, clkout))) as "Total Hours"
You're trying to add a character ':' to integers.
You have to convert (or cast) the integer results...