March 11, 2008 at 2:17 pm
Hello all,
Using SQL Server 2000, I am trying to do a data conversion from a table in one database and update data on a different table on a different database. This is a dirty on time process. How do I combine the three fields one record row into a one field XML data row? I was told somthing about CURSOR usage.
From Data:
User_ID; User_Name; Comment
266;John; This is a data comment.
To Result:
Form_Data field
March 11, 2008 at 2:47 pm
Select
Convert(varchar(10), user_id) + ' ' + user_name + ' ' + comment as row
From
source
For XML AUTO
Will give you one row in xml.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 12, 2008 at 9:20 am
Thanks Jack. Tyler
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply