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 |
|
beady
Starting Member
28 Posts |
 Posted - 2006-08-23 : 18:23:47
|
| I need to use DISTINCT to eliminate duplicates, however my SELECT does contain datatypes of text and so I cannot use DISTINCT. Is there some alternative means of avoiding duplicates? |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-08-23 : 18:47:41
|
don't allow them in your database?you can use substring to split your text datatype and compare thosesubstring(columnName, 1, 8000), substring(columnName, 8001, 8000), substring(columnName, 16001, 8000), ...Go with the flow & have fun! Else fight the flow  blog thingie: http://weblogs.sqlteam.com/mladenp |
 |
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2006-08-24 : 11:14:25
|
| Upgrade to 2005 and use varchar(max)? |
|
|
|
pootle_flump
1064 Posts |
Posted - 2006-08-25 : 05:27:35
|
| Assuming your text columns aren't duplicated and this is due to children in the query then you can create a distinct, derived table and join this to your table containing the text column.HTH |
|
|
|
|
|
|
Alternative to DISTINCT selection when using text?