File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

SQL Server Exception

 
Muhammad Imad Qureshi
Ranch Hand
Posts: 238
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am using follwoing query

SELECT Fax.* FROM Fax
INNER JOIN FaxAccess ON Fax.DocumentNumber = FaxAccess.DocumentNumber
WHERE FaxTypeId = 2 AND isPublic = 0 AND
(FaxAccess.UserAccess LIKE '\Seattle\Police\Detective%' )

UNION

SELECT Fax.* FROM FAX
WHERE FaxTypeId = 2 AND
Fax.isPublic = 1

and both queries return same columns independently but I get following error when I execute the queries with union

Server: Msg 8163, Level 16, State 4, Line 1
The text, ntext, or image data type cannot be selected as DISTINCT.

I would appreciate if someone can help me out. By my question you can guess I am a novice.
 
Muhammad Imad Qureshi
Ranch Hand
Posts: 238
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am found the solution. In one of my column I had an image file.
and because I have one image file in one of my columns that I am selecting
thats why I should do UNION ALL because The UNION operator by default
eliminates duplicate rows from the resultset. The duplicate eliminating
operation is similar to a SELECT DISTINCT. You can't use SELECT DISTINCT on
a column that is text type or image type or ntext type.
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 33674
316
Eclipse IDE Java VI Editor
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Muhammad,
Thanks for posting the solution!
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic