Thank you very much for your answers. That's exactly what I thought. I will use your opinions as a valid answers to my Project Manager that insists of creating database within...

Hi Alex,

It looks like server where your query has bad performance does not have regular maintenance (update statistics, reindex etc.). Check execution plan in all cases.

Use rather OPENROWSET and OPENQUERY than...

Hi Douglas,

Thanks for your stright answer. It looks like I tried to create perpetual motion. Anyhow thanks for giving me peace of mind!

Regards,

Milovan

Hi All,

Thanks for all comments and to Jeff for enclosed SQL code. It is very good! Unfortunatly I could not used because of dead line at Friday (Sydney time zone)...