I would like to ask for you help finding a problem in my XML schema. I need to do a bulk insert into 3 tables that are linked. I have an address, site and customer table. It is an SQL Server 2008 Database
The customer table links to its address in the address table. The Address table contains no links to other tables and the site table contains a link to the customer and to the sites address.
From my understanding of this bulk insert procedure, I need to insert my address for my customer then my customer with a link to its address. Then I want to insert my sites for my customer but they need their addresses too so I want to insert the site
address and then the site with the key relationships to its address and customer row in those tables.
The xsd file is below that I have at the moment:
<?xml version="1.0" encoding="utf-8"
View Complete Post