Double lines in the tables - SQL Server Forums

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

General SQL Server Forums

Data Corruption Issues

Double lines in the tables

Author

Topic

MrSu Sql
Starting Member

4 Posts

Posted - 2007-11-29 : 08:29:50

Hi all we are student of university
and we trying to make application

We are programming in Tsql.we must make a list of backup sets and backup jobs.

Every backupjob can have more then one backupsets. The problem is when we want to put this in table then. We see the costumors name double in it .

For excample

Mr Jurgen has more backupjobs

We see then in our table then

Loginname Wich Status
MRJURGen SET 1 GOOD
Mrjurgen Set 2 Good
Mrjurgen Set 3 NOT ok

What we want that comes like this in a table

Loginname Wich Status
MrJurgen Set 1 Good
Set 2 Good
Set 3 Not ok

But we keep getting MRjurgen in also in the other lines !

The solution that we think that could help is an while loop

But sadly it doesnt work

So we desperate asking here how to do this :(

Thanks

Students

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-11-29 : 08:38:01

Where do you want to show the data?
This feature is known as Suppress if duplicated
If you use reports, use that feature there

Madhivanan

Failing to plan is Planning to fail

MrSu Sql
Starting Member

4 Posts

Posted - 2007-11-29 : 09:28:32

Thank u for answering our question

can u give us a excample how you make Suppress if duplicated??

thanks
Student

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-11-29 : 09:34:38

quote:
Originally posted by MrSu Sql

Thank u for answering our question

can u give us a excample how you make Suppress if duplicated??

thanks
Student

It depends on where you want to show data
Crystal Reports has this feature

Madhivanan

Failing to plan is Planning to fail

MrSu Sql
Starting Member

4 Posts

Posted - 2007-11-29 : 09:46:14

quote:
Originally posted by madhivanan

quote:
Originally posted by MrSu Sql

Thank u for answering our question

can u give us a excample how you make Suppress if duplicated??

thanks
Student

It depends on where you want to show data
Crystal Reports has this feature

Madhivanan

Failing to plan is Planning to fail

We must give this on a website and we doing this with sql 2005 sever.

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-11-30 : 01:25:38

Read my first reply in this page on Suppress if duplicated
http://sqlteam.com/forums/topic.asp?TOPIC_ID=76862&whichpage=2

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources