display first record and suppress duplicate record

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 2000 Forums

SQL Server Development (2000)

display first record and suppress duplicate record

Author

Topic

zionman4
Starting Member

1 Post

Posted - 2011-10-03 : 04:10:04

Hi I have a query that gives me the following data:

select r.request, r.city, s.service, s.complaint
from request r inner join service s on r.requestid = s.requestid
inner join complaint c on r.requestid = c.requestid

request city service complaint
123 - Arcadia - abc - def
123 - New Hall - abc - xyz
123 - Sacramento - mno - xyz
123 - San Diego - mno - xyz

and would like the following results:
request city service complaint
123 - Arcadia - abc - def
123 - New Hall - - xyz
123 - Sacramento - mno -
123 - San Diego - mno -

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-10-03 : 04:49:01

isnt this a presentation issue. i feel like this is a reporting requirement which can be easily dealt with in all reporting tools. Its called suppress duplicates property in SQL reporting services for example.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources