python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - for-xml-path

T-SQL - Save query with XML output including namespace into table or variable

I would like to save the output from the query below into a variable or a table. However it gives an error because the query starts with "With namespace ..." WITH XMLNAMESPACES ( 'urn:oasis:...
test-img

Mark

sql

namespaces

store

for-xml-path

Votes: 0

Answers: 1

Latest Answer

You should assign an expression, use brackets around the select declare @x xml; WITH XMLNAMESPACES ( 'urn:oasis:names:specification:ubl:schema:xsd:CommonAggregateComponents-2' as cac , 'urn:oasis:name...
test-img

Serg

SUM a column, then ADD and DIVIDE in XML (BI Publisher template), weird value?

looking for a little help with calculating a value from XML data in a BI Publisher template. I'm trying to say "If percentage column isn't null, then Sum up the cost column and multiply by 1 + pe...
test-img

ScottHillierDstl

xml

oracle

bi-publisher

for-xml-path

Votes: 0

Answers: 1

Latest Answer

Just needed to format the field itself to a number in the template.
test-img

ScottHillierDstl

How can I make FOR XML PATH return empty elements for an empty result?

How can I make FOR XML PATH return elements when my query returns an empty result? This is what my query looks like: DECLARE @StatementNumber int = 2577 SELECT sl.statement_number [StatementNu...
test-img

JCastillo

sql

sql-server

xml

for-xml-path

Votes: 0

Answers: 1

Latest Answer

Please try the following conceptual solution. It is using SQL Server's XQuery power. You can modify @state parameter value, anything outside of TX or FL, and see what it does. For your real scenario, ...
test-img

Yitzhak Khabinsky

Posts

Questions

Blogs

Jobs