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.
| 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 |
|
|
|
|
|
Double lines in the tables