User Profile

snots34 · Feb 25 '14, 02:48 AM

I have an SQL Query that is outputting as XML like this:

Code:

<root>
<ELECTION>
    <title1>Carroll County Board Dist. 2</title1>
    <PrecintPercent>100</PrecintPercent>
    <Winner>5188</Winner>
    <WinningVotes>1445</WinningVotes>
    <WinningParty>D</WinningParty>
    <Winner1>Gary Imel</Winner1>

...

snots34 · Feb 24 '14, 03:47 AM

This is my query:

Code:

select  rc.[race number] AS RaceNumber,
    max(case when seqnum = 1 then title1 end) as title1,
    max(case when seqnum = 1 then [precinct percent] end) as PrecintPercent,
    max(case when seqnum = 1 then [candidate num] end) as Winner,
    max(case when seqnum = 1 then Votes end) as WinningVotes,
    max(case when seqnum = 1 then party end) as WinningParty,
    max(case

...

User Profile

Profile Sidebar

how can I manipulate my XML ouput using an XSL stylesheet

SQL Query- XML Place Multiple Results into Multiple Nodes