Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dherrera
Starting Member
1 Post |
 Posted - 2004-05-19 : 20:41:58
|
| Hi,Sorry for my bad english, I hope you can understand me.I have a problem. I need to catch the "FOR XML EXPLICIT/AUTO/RAW/..." results in the temporal table or variable in stored procedure.Thanks in advance,DHerrera |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-05-19 : 23:13:47
|
| You can't insert any statement that uses FOR XML into a temp table or variable. You can build it yourself in the procedure (add the appropriate <> tags) and return that into a table or variable.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
|
|
|
Catch XML in Stored procedure