Unir consultas, error de varchar

[kikarodaima]

Gracias. Finalmente lo resolví así:

Select [dbo].[F_MonedaMVForm]('FAC','FS','7332',mvtrade.idmvtrade) as ValorUnitario,mvtrade.PRODUCTO,mvtrade.NOMBRE,mvtr ade.UNDVENTA, 0 AS 'ordimp'
From MVTrade INNER JOIN MTMERCIA ON MVTrade.PRODUCTO = MTMERCIA.CODIGO
Where not MVTrade.PRODUCTO in ('2600','2600A') and
MVTrade.Origen ='FAC' And
MVTrade.TipoDcto='FS' And
MVTrade.NroDcto='7332' union

Select sum(MVTrade.VALORUNIT) AS ValorUnitario,mvtrade.PRODUCTO,mvtrade.NOMBRE,mvtr ade.UNDVENTA, 0 AS 'ordimp'
from mvtrade JOIN MTMERCIA ON MVTrade.PRODUCTO = MTMERCIA.CODIGO
where MVTrade.PRODUCTO in ('2600','2600A') and
MVTrade.ORIGEN = 'FAC' and
MVTrade.TIPODCTO = 'FS' and
MVTrade.NroDcto='7332'
group by PRODUCTO, NOMBRE, UNDVENTA