SQL Server XML

I'm trying to apply techniques I'd normally use to pull data from SQL/Server to pull XML from SQL/Server, and I'm running into a problem.  Here's what I'm doing: 1.  I've built a stored procedure that pulls my data, and renders it into ...

declare @cid uniqueidentifier declare @pid uniqueidentifier set @cid = '0F88363A-5689-42E1-8A1A-86228B9C23C5' set @pid = 'C8F5598F-2A72-4E8D-A833-00C9F152130D' exec dbo.sp_GetReportXml @cid,@pid go gives error "Conversion failed when converting from a character string to uniqueidentifier. " Also tried with '{ ...}' - same error. ...

Hi all! I have an XML like this: <?xml version="1.0" ?> <actions>   <action code="ABC1234" number="1">     <group value="2">       <subgroup value="5"> ...

I want to write a function to delete an node which is specific paremeter from xml.  I known it can use @xml.modify to delete, it seems not work to as: Set @xml.modify('/row/' + @tagname) Which @xml is xml variable and @tagname is node name to be deleted and as ...

Running SQL Server 2005. This is more a watch out than a plea for help! I needed to output data from my database in XML format, so I've been using the "For XML Auto" clause on my T-SQL queries. Realising that outputting the ...

Anyone here that also uses ASP pages? I have a stored procedure that creates XML content the way I want it using FOR XML AUTO, ELEMENTS. At least when I run the query anyway. What I want is to use that SP in an ASP page. When ...