Sfrgttk

Did Shadowfax go to Valinor?

Stopping power of mountain vs road bike

How can I fix/modify my tub/shower combo so the water comes out of the showerhead?

Assassin's bullet with mercury

What is a clear way to write a bar that has an extra beat?

Has there ever been an airliner design involving reducing generator load by installing solar panels?

Why does Kotter return in Welcome Back Kotter?

What mechanic is there to disable a threat instead of killing it?

How can I make my BBEG immortal short of making them a Lich or Vampire?

How much of data wrangling is a data scientist's job?

Today is the Center

A reference to a well-known characterization of scattered compact spaces

Intersection of two sorted vectors in C++

Infinite Abelian subgroup of infinite non Abelian group example

Does a druid starting with a bow start with no arrows?

How could indestructible materials be used in power generation?

Is it inappropriate for a student to attend their mentor's dissertation defense?

1960's book about a plague that kills all white people

Doing something right before you need it - expression for this?

Can I ask the recruiters in my resume to put the reason why I am rejected?

Would Slavery Reparations be considered Bills of Attainder and hence Illegal?

I'm flying to France today and my passport expires in less than 2 months

Were any external disk drives stacked vertically?

How to model explosives?

ms sql query multiple table colums as identical tag (sequel)

ms sql query multiple table colums as identical tagSelect XML values when attribute involvedHow to include concatenated values in a dynamic pivot column value?Parsing Typed XML with a default namespace and inconsistent root nodeHowto query xmlFull text search in XML documentsSQL Row concatenation with XML PATH and STUFF giving aggregate sql errorGet attribute value of XMLDistinct XML values mysqlINSERT/SELECT xml column from one table to anotherms sql query multiple table colums as identical tag

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}

-1

Extending this original question

I am using SQL Server Express 2017

Pretending this is my source table:

+-------------+---------------------------+

| ID | Name   | Age  | HairColor | HasCar |

+-------------+---------------------------+

| 1  | Bert   | 25   | blonde    | 1      |

| 2  | Agnes  | 61   | white     | 0      |

| 3  | Diane  | 43   | brunette  | 1      |

+-------------+---------------------------+

How can get a result looking like this?

<MyRootElement>

    <MyGroupingTag Group="a">

      <MyTag Value="1"      />

      <MyTag Value="Bert"   />    

      <MyTag Value="25"     />

      <MyTag Value="blonde" />

      <MyTag Value="1"      />

    </MyGroupingTag>

    <MyGroupingTag Group="b">

      <MyTag Value="2"        />

      <MyTag Value="Agnes"    />    

      <MyTag Value="61"       />

      <MyTag Value="white"    />

      <MyTag Value="0"        />

    </MyGroupingTag>

    <MyGroupingTag Group="c">

      <MyTag Value="3"         />

      <MyTag Value="Diane"     />    

      <MyTag Value="43"        />

      <MyTag Value="brunette"  />

      <MyTag Value="1"         />

    </MyGroupingTag>

</MyRootElement>

Because of the Group attribute in MyGroupingTag I can't use something like

SELECT... FOR XML PATH('MyTag'), ROOT('MyGroupingTag')

sql-server xml

share

asked 8 mins ago

GeorgeDukeGeorgeDuke

12

New contributor

GeorgeDuke is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

-1

Extending this original question

I am using SQL Server Express 2017

Pretending this is my source table:

+-------------+---------------------------+

| ID | Name   | Age  | HairColor | HasCar |

+-------------+---------------------------+

| 1  | Bert   | 25   | blonde    | 1      |

| 2  | Agnes  | 61   | white     | 0      |

| 3  | Diane  | 43   | brunette  | 1      |

+-------------+---------------------------+

How can get a result looking like this?

<MyRootElement>

    <MyGroupingTag Group="a">

      <MyTag Value="1"      />

      <MyTag Value="Bert"   />    

      <MyTag Value="25"     />

      <MyTag Value="blonde" />

      <MyTag Value="1"      />

    </MyGroupingTag>

    <MyGroupingTag Group="b">

      <MyTag Value="2"        />

      <MyTag Value="Agnes"    />    

      <MyTag Value="61"       />

      <MyTag Value="white"    />

      <MyTag Value="0"        />

    </MyGroupingTag>

    <MyGroupingTag Group="c">

      <MyTag Value="3"         />

      <MyTag Value="Diane"     />    

      <MyTag Value="43"        />

      <MyTag Value="brunette"  />

      <MyTag Value="1"         />

    </MyGroupingTag>

</MyRootElement>

Because of the Group attribute in MyGroupingTag I can't use something like

SELECT... FOR XML PATH('MyTag'), ROOT('MyGroupingTag')

sql-server xml

share

asked 8 mins ago

GeorgeDukeGeorgeDuke

12

New contributor

GeorgeDuke is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

Extending this original question

I am using SQL Server Express 2017

Pretending this is my source table:

+-------------+---------------------------+

| ID | Name   | Age  | HairColor | HasCar |

+-------------+---------------------------+

| 1  | Bert   | 25   | blonde    | 1      |

| 2  | Agnes  | 61   | white     | 0      |

| 3  | Diane  | 43   | brunette  | 1      |

+-------------+---------------------------+

How can get a result looking like this?

<MyRootElement>

    <MyGroupingTag Group="a">

      <MyTag Value="1"      />

      <MyTag Value="Bert"   />    

      <MyTag Value="25"     />

      <MyTag Value="blonde" />

      <MyTag Value="1"      />

    </MyGroupingTag>

    <MyGroupingTag Group="b">

      <MyTag Value="2"        />

      <MyTag Value="Agnes"    />    

      <MyTag Value="61"       />

      <MyTag Value="white"    />

      <MyTag Value="0"        />

    </MyGroupingTag>

    <MyGroupingTag Group="c">

      <MyTag Value="3"         />

      <MyTag Value="Diane"     />    

      <MyTag Value="43"        />

      <MyTag Value="brunette"  />

      <MyTag Value="1"         />

    </MyGroupingTag>

</MyRootElement>

Because of the Group attribute in MyGroupingTag I can't use something like

SELECT... FOR XML PATH('MyTag'), ROOT('MyGroupingTag')

sql-server xml

share

asked 8 mins ago

GeorgeDukeGeorgeDuke

12

New contributor

GeorgeDuke is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

+-------------+---------------------------+

| ID | Name   | Age  | HairColor | HasCar |

+-------------+---------------------------+

| 1  | Bert   | 25   | blonde    | 1      |

| 2  | Agnes  | 61   | white     | 0      |

| 3  | Diane  | 43   | brunette  | 1      |

+-------------+---------------------------+

<MyRootElement>

    <MyGroupingTag Group="a">

      <MyTag Value="1"      />

      <MyTag Value="Bert"   />    

      <MyTag Value="25"     />

      <MyTag Value="blonde" />

      <MyTag Value="1"      />

    </MyGroupingTag>

    <MyGroupingTag Group="b">

      <MyTag Value="2"        />

      <MyTag Value="Agnes"    />    

      <MyTag Value="61"       />

      <MyTag Value="white"    />

      <MyTag Value="0"        />

    </MyGroupingTag>

    <MyGroupingTag Group="c">

      <MyTag Value="3"         />

      <MyTag Value="Diane"     />    

      <MyTag Value="43"        />

      <MyTag Value="brunette"  />

      <MyTag Value="1"         />

    </MyGroupingTag>

</MyRootElement>

share

asked 8 mins ago

GeorgeDukeGeorgeDuke

12

New contributor

GeorgeDuke is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 8 mins ago

GeorgeDukeGeorgeDuke

12

New contributor

GeorgeDuke is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 8 mins ago

GeorgeDukeGeorgeDuke

12

New contributor

GeorgeDuke is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 8 mins ago

GeorgeDukeGeorgeDuke

12