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 |
|
devpurohit
Starting Member
4 Posts |
 Posted - 2012-04-17 : 12:53:05
|
| This time i got out put like thisExample:date name Address----------------------------17-04-2012 test lkkk-----------------------------17-04-2012 abc oooi-------------------------------18-04-2012 xyz ftjjk--------------------------------i want out put like this data as date display at once for same date and their data with thatdate name Address-----------------------------------17-04-2012 test lkkk abc oooi jax lkk---------------------------------18-04-2012 xyx gfgfg jkj jkhk-----------------------------------19-04-2012 cdfs hkj |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-04-17 : 13:51:28
|
| i hope this is for reporting need. If yes, this option is available in most of the reporting tools. Its called suppress/remove duplicates and is available within cell properties in SSRS------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
devpurohit
Starting Member
4 Posts |
Posted - 2012-04-18 : 05:17:41
|
| Not for reporting but multiple same date should appear once and that row might have multiple row which have same date |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2012-04-18 : 05:48:00
|
| Where do you want to show data? This is known as Suppress if duplicated that can be easily done in front endMadhivananFailing to plan is Planning to fail |
|
|
|
devpurohit
Starting Member
4 Posts |
Posted - 2012-04-18 : 13:02:39
|
| ok it's done now with front end |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-04-19 : 00:47:21
|
| good...thats the right approach------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
same date row display multiple row data