DaveK2014 (5/2/2014)
Still get the same errorMsg 421, Level 16, State 1, Line 1
The ntext data type cannot be selected as DISTINCT because it is not comparable.
Very quick and dirty test...I created 2 test tables, 3 columns each; one had int, varchar(3), and ntext. The other had int, varchar(3), and nvarchar(max).
This worked to union them:
select col1,col2,cast(col3 as nvarchar(max)) as col3 from dbo.test1
union
select col1,col2,col3 from dbo.test2
I hope this helps!