Select @DaysCount= count(distinct([Transdate]))

put bracet在trandate上试一试

put bracet on trandate and try it