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 |
|
vmon
Yak Posting Veteran
63 Posts |
 Posted - 2006-09-21 : 10:28:01
|
| I have 2 selects with a union and one of the columns happens to be a Text datatype. I am getting this error: Server: Msg 8163, Level 16, State 4, Line 1The text, ntext, or image data type cannot be selected as DISTINCT.Is there are way to get around this without changing the datatype of the column in the table?Thanks,vmon |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-09-21 : 11:04:54
|
| If not using more than 8000 characters in the TEXT columns, try convert to VARCHAR(8000).Peter LarssonHelsingborg, Sweden |
 |
|
|
|
|
|
Text data type giving me error