select query with merge effect

Question

Hi i would like to ask, if you have those records in database

ID	City	Country
1	New York	USA
2	London	Europe
3	Madrid	Europe
4	Washington	USA

Can you do by some select this kind of view?

ID	City	Country
1	New York	USA
2	London	Europe
3	Madrid
4	Washington	USA

Thanks

Answer 1

It's the part of the client to display the data; if it is able to display it this way ...

But the SQL Server returns data row-wise, as in your first list.

---

Olaf Helper

Blog Xing

Answer 2

And how can you display it by client?

Is for this any command?

Answer 3

hi

Use the Hide Duplicates property on the textbox displaying the Country. Set it to "Details".

Hope this helps!

Answer 4

If you are using SSRS, your can achieve by Grouping data and use single group. 

Answer 5

Hi Triskac,

In order to meet your requirement,please refer to the following steps:
  1. Add the field"Country" as parent group in the table data region and add field"City" and "ID" in detail group.
  2.Select the whole table and in the Tablix properties dialog box,specify the LayoutDirection value with "RTL" in Font section.
  3.Select the textbox which display the "Country"values and in the textbox property dialog box, Specify the TextAlign value with"Center".
The following screen shot show a similar report in my test environmnet, please take as reference.

Regards,
Fanny Liu

---

Fanny Liu
TechNet Community Support

Answer 6

Hi Fanny Liu

ok this I know how to do in report builder 3.

But can you do it just with sql commands?

Thanks