getting distinct recordset back in a record which includes a text field 
Author Message
 getting distinct recordset back in a record which includes a text field
I am trying to eliminate duplicate records in a query which looks like
the following where biog is defined as a text field, comm_dir is a view
so outer joins are not an option

SELECT dv.member_id, last_name, first_name, company, dv.create_date, rm_fit
, rm_tran, biog
FROM comm_dir dv, code c1, council_specialty_relation cs
WHERE (c1.code_id = 101 or c1.parent_code_id = 101)
AND c1.code_id = cs.specialty_code
AND cs.council_member_id = dv.council_member_id
and show_ind = 1
ORDER BY last_name

thank you very much



Sat, 17 Jan 2004 02:19:47 GMT
 getting distinct recordset back in a record which includes a text field

Cant you just do a select distinct?

select distinct dv.member_id, last_name, first_name,
company, etc...

--grant

Quote:
>-----Original Message-----
>I am trying to eliminate duplicate records in a query
which looks like
>the following where biog is defined as a text field,
comm_dir is a view
>so outer joins are not an option

>SELECT dv.member_id, last_name, first_name, company,

dv.create_date, rm_fit
Quote:
>, rm_tran, biog
>FROM comm_dir dv, code c1, council_specialty_relation cs
>WHERE (c1.code_id = 101 or c1.parent_code_id = 101)
>AND c1.code_id = cs.specialty_code
>AND cs.council_member_id = dv.council_member_id
>and show_ind = 1
>ORDER BY last_name

>thank you very much

>.



Sat, 17 Jan 2004 04:21:07 GMT
 getting distinct recordset back in a record which includes a text field
No, a text, ntext, and image fields can not be used in a select with the distinct option specified.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!



Sat, 17 Jan 2004 05:05:27 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Getting image into field (SQL 7) and getting it back out

2. text field to HTML with text style included?

3. Getting Unique records...DISTINCT I guess...

4. Converting Memo fields back to Text fields

5. Getting back @@INDETITY from SQL DB from a Recordset

6. Getting recordset back from web server

7. problems getting back output params AND recordset

8. Getting multiple recordsets back from a procedure in VB6

9. Getting a distinct row when returning multiple fields

10. Getting back an identity field value after an insert SQL statement

11. Problem in using DISTINCT clause with TEXT datatype field

12. Problem in using DISTINCT keyword with TEXT datatype field


 
Powered by phpBB® Forum Software