Eliminating repeating data values

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.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Eliminating repeating data values

Author

Topic

w_cohen
Starting Member

6 Posts

Posted - 2008-05-13 : 16:02:40

I am querying several tables and piping the output to an Excel spreadsheet.
Several (not all) columns contain repeating data that I'd prefer not to include on the output. I only want the first row in the set to have that data. Is there a way in the query to do this under SQL 2005?

As an example, my query results are as follows (soory if it does not show correctly):
OWNER BARN ROUTE DESC VEH DIST CASE
BAR BAR TRACKING #7 0328 VEH 328 328 69.94 1393
BAR BAR TRACKING #7 0328 VEH 328 328 69.94 1393
BAR BAR TRACKING #7 0328 VEH 328 328 69.94 1393
DAX DAX TRACKING #9 398 VEH 398 398 34.94 2471
DAX DAX TRACKING #9 398 VEH 398 398 34.94 2471
DAX DAX TRACKING #9 398 VEH 398 398 34.94 2471
TAX TAX TRACKING #2 407 407 54.39 1002
TAX TAX TRACKING #2 407 407 54.39 1002
TAX TAX TRACKING #2 407 407 54.39 1002

I only want the output to be:
OWNER BARN ROUTE DESC VEH DIST CASE
BAR BAR TRACKING #7 0328 VEH 328 328 69.94 1393

DAX DAX TRACKING #9 398 VEH 398 398 34.94 2471

TAX TAX TRACKING #2 407 407 54.39 1002

Thanks,
Walt

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-05-13 : 16:04:17

You can use DISTINCT or GROUP BY.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Database maintenance routines:
http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx

w_cohen
Starting Member

6 Posts

Posted - 2008-05-16 : 13:16:23

Sorry, I should have said (and shown in the example) that the rows have other columns that are NOT unique. I don't want to show the repeating data values.

OWNER BARN ROUTE DESC VEH DIST CASE COL1 COL2 COL3
BAR BAR TRACKING #7 0328 VEH 328 328 69.94 1393 1 1 1
BAR BAR TRACKING #7 0328 VEH 328 328 69.94 1393 2 2 2
BAR BAR TRACKING #7 0328 VEH 328 328 69.94 1393 3 3 3
DAX DAX TRACKING #9 398 VEH 398 398 34.94 2471 1 1 1
DAX DAX TRACKING #9 398 VEH 398 398 34.94 2471 2 2 2
DAX DAX TRACKING #9 398 VEH 398 398 34.94 2471 3 3 3
TAX TAX TRACKING #2 407 407 54.39 1002 1 1 1
TAX TAX TRACKING #2 407 407 54.39 1002 2 2 2
TAX TAX TRACKING #2 407 407 54.39 1002 2 2 2

I only want the output to be:
OWNER BARN ROUTE DESC VEH DIST CASE COL1 COL2 COL3
BAR BAR TRACKING #7 0328 VEH 328 328 69.94 1393 1 1 1
2 2 2
3 3 3
DAX DAX TRACKING #9 398 VEH 398 398 34.94 2471 1 1 1
2 2 2
3 3 3
TAX TAX TRACKING #2 407 407 54.39 1002 1 1 1
2 2 2
2 2 2

Walter

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-05-16 : 13:24:58

quote:
Originally posted by w_cohen

Sorry, I should have said (and shown in the example) that the rows have other columns that are NOT unique. I don't want to show the repeating data values.

OWNER BARN ROUTE DESC VEH DIST CASE COL1 COL2 COL3
BAR BAR TRACKING #7 0328 VEH 328 328 69.94 1393 1 1 1
BAR BAR TRACKING #7 0328 VEH 328 328 69.94 1393 2 2 2
BAR BAR TRACKING #7 0328 VEH 328 328 69.94 1393 3 3 3
DAX DAX TRACKING #9 398 VEH 398 398 34.94 2471 1 1 1
DAX DAX TRACKING #9 398 VEH 398 398 34.94 2471 2 2 2
DAX DAX TRACKING #9 398 VEH 398 398 34.94 2471 3 3 3
TAX TAX TRACKING #2 407 407 54.39 1002 1 1 1
TAX TAX TRACKING #2 407 407 54.39 1002 2 2 2
TAX TAX TRACKING #2 407 407 54.39 1002 2 2 2

I only want the output to be:
OWNER BARN ROUTE DESC VEH DIST CASE COL1 COL2 COL3
BAR BAR TRACKING #7 0328 VEH 328 328 69.94 1393 1 1 1
2 2 2
3 3 3
DAX DAX TRACKING #9 398 VEH 398 398 34.94 2471 1 1 1
2 2 2
3 3 3
TAX TAX TRACKING #2 407 407 54.39 1002 1 1 1
2 2 2
2 2 2

Walter

I believe this is a front end issue. Are you showing this on some reports? Its very easy to do this at your front end application. There are options in applications to hide repeating data fields like this.

w_cohen
Starting Member

6 Posts

Posted - 2008-05-16 : 14:35:46

I have no front end. I run the query and pipe the data results to an Excel spreadsheet (so I guess Excel is my front end).

Walt

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources