clear markdown compare help donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 462281 distinct fiddles created so far.

CREATE TABLE ACCOUNTS ( AGE int ); INSERT INTO ACCOUNTS(AGE) VALUES(30),(40),(50);
3 rows affected
 hidden batch(es)


WITH XMLNAMESPACES ( 'http://www.w3.org/2001/XMLSchema-instance' AS abc, 'uri' AS def ) SELECT CASE WHEN AGE <= 30 THEN 'BUYER' END AS [def:GIRL], CASE WHEN AGE >=40 THEN 'SELLER' END AS [def:BOY] FROM ACCOUNTS FOR XML PATH(''), ROOT('abc:OilCompany'), TYPE;
(No column name)
<abc:OilCompany xmlns:def="uri" xmlns:abc="http://www.w3.org/2001/XMLSchema-instance"><def:GIRL>BUYER</def:GIRL><def:BOY>SELLER</def:BOY><def:BOY>SELLER</def:BOY></abc:OilCompany>
 hidden batch(es)