...FROM Sales.SalesOrderHeader FOR XML EXPLICIT, TYPE) RETURN @xml END GO DECLARE @xml ....test exec temp_workflow_usage I get the FOR XML clause is not allowed in a ... xml result from a proc using that uses xml explicit and it seems like i'm getting an int back?...'t I be getting back an xml type? Also also get this error....

... temp_workflow_usage I get the FOR XML clause is not allowed in ... W. DeBetta" wrote: Procs always return an int or null. You ... a temp table with an xml column and work from there...result from a proc using that uses xml explicit and it...I be getting back an xml type? Also also get this...The data types varchar and xml are incompatible in the add...

... temp_workflow_usage I get the FOR XML clause is not allowed in ... W. DeBetta" wrote: Procs always return an int or null. You ... a temp table with an xml column and work from there...result from a proc using that uses xml explicit and it...I be getting back an xml type? Also also get this...The data types varchar and xml are incompatible in the add...

...GO CREATE TABLE #temp (XmlReturn XML) INSERT INTO #temp EXEC dbo...temp_workflow_usage I get the FOR XML clause is not allowed in...W. DeBetta" wrote: Procs always return an int or null. You...insert the results of the proc into a temp table with...result from a proc using that uses xml explicit and it...I be getting back an xml type? Also also get this...

...exec temp_workflow_usage I get the FOR XML clause is not allowed in a...Peter W. DeBetta" wrote: Procs always return an int or null. You either... a temp table with an xml column and work from there... ... result from a proc using that uses xml explicit and it ... I be getting back an xml type? Also also get this ... The data types varchar and xml are incompatible in the add ...

...have been unseccesful in getting the XML into a temp table. I will...Peter W. DeBetta" wrote: Procs always return an int or null. You either...into a temp table with an xml column and work from there...... result from a proc using that uses xml explicit and it ...t I be getting back an xml type? Also also get this ... The data types varchar and xml are incompatible in the add ...

Procs always return an int or null. You either need to make dbo.... or insert the results of the proc into a temp table with an xml column and work from there... ...xml result from a proc using that uses xml explicit and it seems like i'm getting an int back? Why wouldn't I be getting back an xml type? Also also get this ...> The data types varchar and xml are incompatible in the add ...

... to get the xml result from a proc using that uses xml explicit and it seems like i'm getting an int back? Why wouldn't I be getting back an xml type? Also also get this error. declare @xml... exec @xml = dbo.temp_workflow_usage print '@xml =' + @xml Msg 402, Level 16, State 1, Line 3 The data types varchar and xml are incompatible in the add operator. Thanks for ...

... 1. Using CLR proc to create the XML docment Least likely to be your fried as you... the table data and returns an XML doc. Ick! :) I am ...go create table dbo.Products(productID int identity(1,1) primary key, ... from dbo.products p for xml path(''),root('basicExample'),elements xsinil,type ... that I needed FOR XML PATH instead of EXPLICIT (yes, I was on ...