Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Help with this FOR XML EXPLICIT statement in MS SQL2000

rhaazyrhaazy Member Posts: 2
this is the XML I WANT:

<?xml version="1.0" encoding="utf-8" ?>
-
-
200
XXXXX
XXXXX
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE



This is the XML I am getting right now :

<?xml version="1.0" encoding="utf-8" ?>
-
-




















Hopefully you can notice the difference....anyway here is the statement that gives me what I have right now:

select 1 as Tag, 0 as Parent, ID as [Configuration!1!ID], PID as [Configuration!1!PID], Name as [Configuration!1!Name], UOM as [Configuration!1!UOM], Value as [Configuration!1!Value] from tblProfile1 where MessageID = '1' for xml explicit

Sign In or Register to comment.