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 |
|
cheche
Starting Member
1 Post |
 Posted - 2004-07-27 : 14:29:48
|
Hi, Im new in SQL, but I would like to do something like this: name group score collection point 1 4 -------------- 5 5 collection point 2 6 6your got the idea, the problem is, how I do this without getting the name for every group? I'll appreciate any help  |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-07-27 : 14:38:23
|
| Actually I didn't get the idea. Could you explain it in better detail?Tara |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-07-27 : 14:53:27
|
| I'm confused. collection point and collection point are the same thing aren't they????MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
elmalloc
Starting Member
13 Posts |
Posted - 2004-07-27 : 15:20:35
|
I'm also confused, please re describe the problem and we will help you further. Thanks!ELmO |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2004-07-29 : 17:29:21
|
Part of the problem is that you put tried to line up your data sample using spaces which normal HTML strips. However, I have re-posted your example using CODE tags to straighten it out a bit. name group score collection point 1 4 -------------- 5 5 collection point 2 6 6 This formatting problem is one reason that we so often request people give us their DDL (CREATE TABLE) statements and DML (INSERT) statements so we can easily re-create it on our own systems. And since you haven't provided a SELECT statement either, I'm really taking a stab in the dark here. I'm guessing that you are getting a result set where "collection point" is repeated for multiple rows, and then "collection point 2" is repeated for multiple rows, etc. And you want to display it with blank space in place of the repeated data.And the answer is that this really is a front-end display feature and not a database querying feature. I would create the code in the front-end to suppress repeated values and not worry about the database.-----------------------------------------------------Words of Wisdom from AjarnMark, owner of Infoneering |
|
|
|
|
|
|
Im new in SQL