InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 26 May 2013 02:22:38 GMT20http://www.sqlservercentral.com/Forums/Topic1385250-21-1.aspxIf i understand you correctly, you have an xml instance as a string which you want to assign directly to an xml variable whilst at the same time, populating some nodes in the xml string with other variables from the transaction scope? I'm probably not entirely understanding everything, but I have come up with this:[code="sql"]DECLARE @FullPathAndName varchar(100) SET @FullPathAndName = 'C:\DBA_Share\SSRS\Output\MyReport.rpt'DECLARE @xVar XML = ''SELECT @xVar = @xVar.query('for $x in ("") return<package name="\File System\ReportToExcel" owner="sa" runAs=""> <variable name="Cnfg_ReportPath" value="C:\DBA_Share\SSRS\"/> <variable name="vSourceQuery" value="select * from dbo.sometable"/> <variable name="vFileName" value="{sql:variable("@FullPathAndName")}"/></package>')SELECT @xVar[/code]Does this help? if not, then if you can go into a bit more of the scenario that you have and what is your end goal.Thu, 15 Nov 2012 14:20:32 GMTarthurolcothttp://www.sqlservercentral.com/Forums/Topic1385250-21-1.aspxIs it possible to set the value of an XML attribute in an XML fragment using a relational variable that is declared and initialised elsewhere in the code block or stored procedure, e.g.[code="sql"]DECLARE @FullPathAndName varchar(100) SET @FullPathAndName = 'C:\DBA_Share\SSRS\Output\MyReport.rpt'[/code][code="xml"]DECLARE @xVar XML SET @xVar = '<package name="\File System\ReportToExcel" owner="sa" runAs=""> <variable name="Cnfg_ReportPath" value="C:\DBA_Share\SSRS\"/> <variable name="vSourceQuery" value="select * from dbo.sometable"/> <variable name="vFileName" value="@FullFileName"/></package>'[/code]I know it is possible to use {sql:variable} when building an xml fragment from a query, e.g.[code="xml"]DECLARE @price money=2500.00SELECT ProductID, Production.ProductModel.ProductModelID,CatalogDescription.query('declare namespace pd="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelDescription"; <Product ProductID="{ sql:column("Production.Product.ProductID") }" ListPrice="{ sql:column("Production.Product.ListPrice") }" DiscountPrice="{ sql:variable("@price") }" />') FROM Production.Product[/code]..but that's not what I want to do here.ThanksLempsterThu, 15 Nov 2012 09:40:22 GMTLempster