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 |
|
PBoy
Starting Member
22 Posts |
 Posted - 2015-01-14 : 16:49:39
|
HI All,Just wondering if itis possible as I have not seen anything on the net that would allow me to do it. I'm looking to blanks out values if its duplicated kind of like what a pivot table does in excel would rather have sql do it rather than downloading it to excel and then doing it. I have used sql pivots in the past but don't think they will do what I need her.raw Data excel example Any help would be Great.CheersP |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2015-01-14 : 16:52:37
|
| Do you mean that you don't want to see "Bridget O'Neill" on each row in the group but only for the first row in the group (as an example)? If so, then yes it is possible in SQL, however it would be extremely complex. Instead use a reporting tool such as SSRS, which can do this very easily.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
PBoy
Starting Member
22 Posts |
Posted - 2015-01-14 : 16:57:26
|
quote:
Originally posted by tkizer
Do you mean that you don't want to see "Bridget O'Neill" on each row in the group but only for the first row in the group (as an example)? If so, then yes it is possible in SQL, however it would be extremely complex. Instead use a reporting tool such as SSRS, which can do this very easily.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/
Hi Tara,yeah that is what I'm after, I know things like SSRS can do it problem is the thing that is outputting the sql is a 3rd party app that does not do it so if I could just pass it the data in the format I want its easier for it just to display it. Plus my work is not running SSRS.CheersP |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2015-01-15 : 13:54:13
|
| I can't provide any guidance on this.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
Grouping Data