Merging of Duplicate data in a single column in SQL Server 2008

Question

In SQL Server, we are getting the result as shown here:

But, we need the output as shown here:

enter image description here

Is there any way we can merge the duplicate data through asp.net front-end or through SQL Query / Stored procedure?

Refer to this post: http://stackoverflow.com/questions/9074403/how-to-render-a-data-table-with-multiple-rowspan-columns-with-listview — Mhd. Yasseen, Dec 04 '12 at 08:31
@TimSchmelter : Can you Please elaborate? I mean a example or a link where i can find exact Output shown above. — Abhijeetchindhe, Dec 04 '12 at 09:20

score 0 · Answer 1 · answered Dec 04 '12 at 09:26

0

It may not be the preferred solution but it may help you to get data in more appropiate way:

SELECT * FROM [{yourDb}].[dbo].[{yourTb}] ORDER BY ProductName ASC
COMPUTE sum(Quantity) BY ProductName

Result : Item OrderId Quantity

Banana 31 2

Sum 6

-- continued

Item OrderId Quantity

Sum 21

answered Dec 04 '12 at 09:26

Mohit Pandey

thanks for the reply, but that's not what i want. I an able to find the values required, but i want the UI to show the output as shown above in Image2 – Abhijeetchindhe Dec 04 '12 at 10:01
or perhaps Using SQL Server query/Stored Procedure. – Abhijeetchindhe Dec 04 '12 at 13:52

score 0 · Answer 2 · answered Dec 05 '12 at 07:56

You can return two tables from stored procedure , one table is having only product detail with total field and another one is having order detail.

Put grid with inner grid.

Now bind parent grid with product table and 2nd grid with order table, it will solve your problem.