Database values to be display in horizontal

Question

1.00/5 (1 vote)

See more:

Hi

I have Database values with 3 fields, Im exporting this fields to Excel sheet,
I got the code to export to excel sheet, But I need modification in exporting the excel sheet,

1. The output of the excel sheet need to remove duplicates values for database and if the alarms having alarms1, alarms2 then this values show on rows

Site Node Alarms

A B alarms1
A B alarms1
A c alarms2
A B alarms2

Output of excel sheet should be

Site Node AlarmsA AlarmsB AlarmC

A B alarms1 alarms2
A c alarms2

Posted 25-Feb-15 0:19am

Member 11338695

Updated 25-Feb-15 1:00am

v2

Add a Solution

Comments

Sergey Alexandrovich Kryukov 25-Feb-15 7:36am

"Display in horizontal" is the UI concept. Data is neither "horizontal" nor "vertical". The answer depends on your UI and requirements...
—SA

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2015-02-25T20:55:00

All you need is called Pivot[^].

SQL

SELECT Site, [alarm1],[alarm2],[alarm3]
FROM (
    SELECT Site, [Node], Alarms
    FROM TableName
    ) AS DT
PIVOT(MAX(Alarms) FOR [Node] IN([alarm1],[alarm2],[alarm3])) AS PT

Result should looks like:

Site B       C
A    Alarms1  NULL
A    Alarms2  NULL
A    NULL    Alarms2

Note that there is no way to pivot data the way you want.