InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 17:31:59 GMT20http://www.sqlservercentral.com/Forums/Topic1379087-338-1.aspxNo need to be embarrassed and you're welcome.You'd be surprised how often the simplest issue is uncovered quickly by a second set of eyes. In this case, I happened to have done a lot of dynamic SQL of late so the answer kind of jumped out at me.And it helped a lot to have code that was easily modified to run on my SQL.Wed, 31 Oct 2012 19:45:20 GMTdwain.chttp://www.sqlservercentral.com/Forums/Topic1379087-338-1.aspxThanks so much. Its embarrassing, thats so simple. I couldn't see the wood for the trees :blush:Wed, 31 Oct 2012 19:41:24 GMTphil.layzellhttp://www.sqlservercentral.com/Forums/Topic1379087-338-1.aspxTry this:[code="sql"]DECLARE @tApplXML XML ,@SQL NVARCHAR(max),@ParmDefinition NVARCHAR(1024) ,@applnbr intset @applnbr = 24 SET @SQL = N'SELECT @ptApplXML = (SELECT * FROM [database].[dbo].[table] WHERE [ApplNbr] = @pApplNbr FOR XML PATH(''database.table''))'SET @ParmDefinition = N'@pApplNbr INT,@ptApplXML xml OUTPUT'PRINT @SQLEXECUTE sp_executeSQL @SQL,@ParmDefinition,@pApplNbr = @ApplNbr,@ptApplXML= @tApplXML OUTPUT select @tApplXML[/code]Wed, 31 Oct 2012 19:25:11 GMTdwain.chttp://www.sqlservercentral.com/Forums/Topic1379087-338-1.aspxHi,I am trying to get an xml blob into a var from dynamic sql. However, whenever I run this: DECLARE @tApplXML XML ,@SQL NVARCHAR(max),@ParmDefinition NVARCHAR(1024) ,@applnbr intset @applnbr = 24 SET @SQL = N'SELECT * FROM [database].[dbo].[table] WHERE [ApplNbr] = @pApplNbr FOR XML PATH(''database.table'')'SET @ParmDefinition = N'@pApplNbr INT,@ptApplXML xml OUTPUT'EXECUTE sp_executeSQL @SQL,@ParmDefinition,@pApplNbr = @ApplNbr,@ptApplXML= @tApplXML OUTPUT select @tApplXMLFirstly I get the XML returned from the OUTPUT , then I get a NULL value. I need @tApplXML to retain the XML value. But whatever I try I cant seem to get it to work.... :pinch:Can anyone point me in the right direction?Many thanks, Phil Tue, 30 Oct 2012 17:13:24 GMTphil.layzell