MSSQL – aggregate function on ntext – group by

 SELECT min(CONVERT(NVARCHAR(max), my_ntext_filed)) AS my_agg_ntext_filed FROM tbl_test GROUP BY id  

Comments are closed.