The text, ntext, or image data type cannot be selected as DISTINCT.
Database
2
Posts
2
Posters
0
Views
1
Watching
-
The text, ntext, or image data type cannot be selected as DISTINCT. how to solve this problem
The best way to do this is to place your text/image type in a separate table and then reference them through an FK which can be handled with
SELECT DISTINCT.Deja View - the feeling that you've seen this post before.