|
Gracias
Gracias mil!!!
Funcionó como me dijeron, colocando Cast en los dos primeros campos.
Nuevamente gracias!!!
Select
Cast(T.BRANCH_CODE as Varchar(10)) as Terminal,
Cast(M.Description as Varchar(30)) As Descripcion,
sum(T.TOTAL_AMOUNT) as Total
...
...
UNION
Select
cast(Count(Distinct(T.BRANCH_CODE)) as VarChar(10)) As Terminal,
Cast('TOTAL' as Varchar(30)) As Descripcion,
Sum(T.TOTAL_AMOUNT) As Total
....
|