>>>Hi All -
>>>
>>>It seems like I should know how to do this but for some reason I am drawing a blank. Suppose you have 2 tables in a 1 to many raltionship. Table1 contains data about various businesses.
>>>Table2 (child) contains notes (memo field) about those businesses.
>>In SQL Server you will use XML PATH('') approach for this.
>
>OK Thanks Naomi. I have a UDF to do that but using it from asp is getting a little complicated. Perhaps I'll bite the bullet and move it all to SQL Server. Can you recommend a good technique for moving data from VFP to SQL Server2008? The import wizard seems to choke on VFP's OLE driver.
Doug Hennig has an article about SQLXMLBulkLoad that you may try.
http://doughennig.blogspot.com/2006/07/sqlxmlbulkload-rocks.html
If it's not broken, fix it until it is.
My Blog