thanks a lot hunchback!!!

I don't understand a thing from the code, but it works perfectly. 🙂

here is the file. so the result should look like this:

Hostname DBInstanceName DatabaseName

host1 instance 1 ...

Thank you for the answer, but it's not exactly how I need it. As for the xml file, I cannot do anything. I see that you used an ID for...

Thank you very much. I left the insert into statement last and probably that's why I got the error message at ELSE statement. The query will return maximum 15 rows,...

Thank you Mark