?
Solved

UNION query and image data type

Posted on 2010-11-10
3
Medium Priority
?
725 Views
Last Modified: 2012-05-10
I have a UNION query that defines a view.  One of the columns in the query is a image data type.  When I try to save the view, I get this message:

"The image data cannot be selected as DISTINCT because it is not comparable".  

I understand how image data is not comparable, but where is the DISTINCT coming from?  I am not specifying DISTINCT.  Is there a way around this?
0
Comment
Question by:HLRosenberger
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 2000 total points
ID: 34101925
UNION is a implicit DISTINCT.

please use UNION ALL
0
 
LVL 1

Author Comment

by:HLRosenberger
ID: 34102214
Thanks!
0
 
LVL 1

Author Closing Comment

by:HLRosenberger
ID: 34102216
Thanks!
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question