要在MSSQL-2005中合并数字，应使用CAST
CAST(loginsFailed AS VARCHAr(10)) + '/' + CAST(LoginCount AS VARCHAr(10))
上面的loginsFailed和loginCount实际上是您的
select count distinct片段
我希望这行得通
CAST ((SELECT COUNT(DISTINCT loginsFailed) FROM users WHERe users.employeedID = userDetails.employeeID AND users.startdate = 01-01-2013) AS VARCHAr(10))+ '/' +CAST ((SELECt COUNT(DISTINCT logins) FROM users WHERe users.employeedID = userDetails.employeeID AND users.startdate = 01-01-2013) AS VARCHAr(10))
