Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Cyanider
Starting Member
7 Posts |
 Posted - 2004-09-27 : 17:48:49
|
| TEXT and IMAGE datatypes may not be selected as DISTINCT.There is a way to override this message and actually do the query if i make an union? I'm using MS SQL 6.5 |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2004-09-27 : 17:57:46
|
| Show us the query you are trying. As I mentioned earlier today on another thread, one of the worse habits I see all the time in SQL is people randomly adding DISTINCT to queries to get the results they think they need, until it "looks" right. More often than not you are either including tables in the query you shouldn't be, joining incorrectly, or approaching your logic the wrong way ....- Jeff |
 |
|
|
|
|
|
UNION query, why not text/image columns ?¿?