display table in hierarcies

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » display table in hierarcies

display table in hierarcies

Rate Topic

Display Mode

Topic Options

Author

Message

peleg

Posted Tuesday, September 11, 2012 3:33 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 12:15 AM
Points: 123, Visits: 502

i want to display a table in Hierarchie.
the thing is that the table dosen't have parent id or somthing like that.
attached is an example for before and after

10X :)

Post #1357236

Brandie Tarvin

Posted Tuesday, September 11, 2012 4:20 AM

SSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 12:39 PM
Points: 6,668, Visits: 5,695

I can't see your example. Can you post it another way?

Brandie Tarvin, MCITP Database Administrator, MCDBA, MCSA

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Post #1357275

peleg

Posted Tuesday, September 11, 2012 6:33 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 12:15 AM
Points: 123, Visits: 502

this is the url to the image
[url=http://s14.postimage.org/my8x11lnz/image.jpg][/url]

Post #1357360

Brandie Tarvin

Posted Tuesday, September 11, 2012 6:55 AM

SSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 12:39 PM
Points: 6,668, Visits: 5,695

The first thing I advise is taking a look at what you actually want mapped. It doesn't make sense to me.

You want app3 stuff mapped to app4?

The second thing I recommend is giving us the DDL for the table, an INSERT statement with sample data, and then post a typed example (rather than an image) of what you want the results of the query to look like (because that's not the same thing as the excel sheet image you posted).

Then we can help you find your best options.

In the meantime, I can recommend that you look into Row_Number() and Common Table Expressions.

Brandie Tarvin, MCITP Database Administrator, MCDBA, MCSA

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Post #1357373

peleg

Posted Tuesday, September 11, 2012 6:57 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 12:15 AM
Points: 123, Visits: 502

solved
select CASE WHEN MIN(t.r) = 1 then t.name1
ELSE ''
END as name1,
t.name2, t.name3, sum(t.sum1), sum(t.sum2)
from (select *, ROW_NUMBER() over(partition by name1 order by name1) r
from #tbl1) as t
group by t.name1, t.name2, t.name3

Post #1357375

Brandie Tarvin

Posted Tuesday, September 11, 2012 7:53 AM

SSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 12:39 PM
Points: 6,668, Visits: 5,695

Glad I could help.

Brandie Tarvin, MCITP Database Administrator, MCDBA, MCSA

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Post #1357425

« Prev Topic | Next Topic »

Permissions