SQL Server XML

im trying to do a xquery hello world in sql server 2005 but i keep getting this error: select foo.query('return <z/>') as result from foo Msg 4121, Level 16, State 1, Line 3 Cannot find either column "foo" or the user-defined function or aggregate ...

I am reading 2 values from a database table, Status and SubStatus are the column names.  I am trying to create my output as xml. SELECT tablename.status as '@status'              ,tablename.substatus ...

Unable to start TSQL Debugging. Could not attach to SQL Server Process on 'srvname'. The RPC server is unavailable. I get this error when I try to run a SQL Server Project with a CLR stored Procedure in it. The target DB is SQL Server 2005 and im using VS 2005. I ...

I can send an XML document to a stored proc, and in the SP use sp_PrepareDocument and OpenXML to produce a table that can be used in an insert statement like     insert mytbl(a,b,c) select * from OpenXML.... ...

I have a complex query that is doing nesting and recursive loops in an ASP page, however this is taking way to long to process so I thought I could put it in a stored procedure.  However, this is proving harder ...

Well, very interesting stuff, trying different syntax and mechanics! This is based on a tiny XML message, as seen in recent messages from me.  Results on larger (2+ megabyte) will probably be very different - I saw a 60x difference on one the other day, and in these tests, nothing of that ...