I need help adding text to a select statement
select '<b>Subtotal:</b>' + (@Query1 - @Query2)
@Query1 and @Query2 are int values in a stored procedure
@Query1 looks something like
Select @Query1 = Sum(Total)
from (select distinct Total, type,unitid
where convert(char(8), Date, 112) = @Date -1)as TMP
The error I get is 'Syntax error converting the varchar value to a column int'