We are using rda pull
To overcome performance issue I converted my data as xml in a big varchar
with the following query
SELECT property.*,
(SELECT job.*,
(SELECT jobdetails.*
FROM dbo.jobdetails jobdetails
WHERE jobdetails.keyjobid = job.keyjobid
AND keyuserid = 'DEMO'
FOR XML AUTO, ELEMENTS, TYPE)
FROM dbo.job job
WHERE job.keyproperty = property.keyproperty
AND keyuserid = 'DEMO'
FOR XML AUTO, ELEMENTS, TYPE)
FROM svsextract.dbo.property property
where property.keyproperty = 30452
FOR XML AUTO
and am pulling it which is much faster.
However I need to find a quick way to instal data from this xml to database.
If I use dataset I can read my data into that dataset.
However I tried to use update with dataadapter it does not work.
I could not decide what my select query should be.
I need to know how to use data adapter with complex queries.
I could not get it work so far.
Please help
Thanks
Reside Ozsoy