Hi All,

this article helps a lot to get an idea of solving my problems regarding sql-server data. my query looks like this:

SELECT

Company.UnternehmenName,

Company.UnternehmenID,

Department.Bereichname,

Department.BereichID,

Process.ProzessName,

Process.ProzessID,

SubProcess.SubProzessName,

SubProcess.SubProzessID

FROM Company

LEFT JOIN Department

ON Company.UnternehmenID = Department.BereichUnternehmenID

left JOIN Process

ON Department.BereichID = Process.BereichID

left join SubProcess

on Process.ProzessID = SubProcess.ProzessID

for xml auto,elements,type, ROOT('Company_Structure')

Anyhow the call of cmd.ExecuteXmlReader() runs into error. (InvalidOperationException)

What do I miss??

Regards Jörn