XML OUPUT - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

XML OUPUT

Author

Topic

avmreddy17
Posting Yak Master

180 Posts

Posted - 2009-05-18 : 19:25:20

Is the below O/P possible with SQL Server 2000..
Thanks for any Help

sample Data:-

SMSymbol Symbol PrimaryExchange
---------------- ---------------- ---------------
ABX.SM ABX NYSE
ABX.SM ABX.TO TSX
AEM.SM AEM NYSE
AEM.SM AEM.TO TSX

Output in XML:

<SMSymbol ABX.SM >
< Symbol = ABX PrimaryExchange = NYSE / >
< Symbol = ABX.TO PrimaryExchange = TSX/ >
< /SmSymbol >

<SMSymbol AEM.SM >
< Symbol = AEM PrimaryExchange = NYSE />
< Symbol = AEM.TO PrimaryExchange = TSX />
< /SmSymbol >

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-07-18 : 16:45:28

Here is a starter

DECLARE	@Sample TABLE
	(
		SMSymbol VARCHAR(20),
		Symbol VARCHAR(20),
		PrimaryExchange VARCHAR(20)
	)

INSERT	@Sample
SELECT	'ABX.SM', 'ABX', 'NYSE' UNION ALL
SELECT	'ABX.SM', 'ABX.TO', 'TSX' UNION ALL
SELECT	'AEM.SM', 'AEM', 'NYSE' UNION ALL
SELECT	'AEM.SM', 'AEM.TO', 'TSX'

SELECT	SMSymbol AS [@SMSymbol],
	Symbol AS [Symbol/@Symbol],
	PrimaryExchange AS [Symbol/@PrimaryExchange]
FROM	@Sample
FOR XML	PATH('SMSymbol'),
	ROOT('SE')

N 56°04'39.26"
E 12°55'05.63"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources