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 |
|
littlewing
Starting Member
33 Posts |
 Posted - 2008-08-28 : 09:00:09
|
| I have a table that has an XML column along with an id, and date column. I store an xml document in the formdata column, id is an autocounter.contactid (int pk autocounter)formdata (xml)datereceived (datetime)I have an OPENXML query that pulls data from the formdata field but is it possible to "append" the other columns from this table and return a recordset? Is a temp table the correct approach?Thanks. |
|
|
|
|
|
Adding a column to an OPENXML query