|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
 |
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
|
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
Dev Articles Community Forums Sponsor:
|
|
|
|
#1
February 8th, 2004, 03:43 PM
|
|||
|
|||
|
distinct query
Hi,
I'm trying to come up with a query to remove redundant rows from a dataset. schema: Idx, DeptCode, Comments I want to remove a row from the query if there exists two rows that contain the same values in the DeptCode and Comments field (respectively) and the Comments field is not null.. Any ideas? Any help will be much appreciated.!
|
|
#2
February 8th, 2004, 06:55 PM
|
||||
|
||||
|
Have a read of these two links:
http://www.sqlteam.com/item.asp?ItemID=3331 http://www.4guysfromrolla.com/webte...q051200-2.shtml
|
|
| Viewing: Dev Articles Community Forums > Databases > Microsoft SQL Server > distinct query |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
