Hello all and thanks for the time spend on answering my posted question.

Originally i came across with a similar t-sql already posted by Hugo. That's definitely the simplest and quickest...

Please remember, my rewrite was done in a vaccuum. I had no tables, sample data, or expected results with which to test my code. I can only hope it was...

Hello vidya_pande,

Maybe you didn't read completely the thread from the beginning.

I once had a generic view with some performance issues and tried out TVF in order to improve query result...

Thanks a lot guys!

So, check out my conclusions after trying your suggestions.

1º Comment:

Lamprey13 and Jeff Moden: You were right, i could re-write my MTVF in order to use ITVF instead.

2º...

Thanks for quick answers.

About ITVF suggestion, it will not work, because my TVF has logic inside.

I'll try to provide further info as requested.

Here's the original t-sql of generic view:

WITH SubCategoriaUtilizador...

Worked like a charm. Bodystream seems to be the answer...

Thanks once more.

Thanks a lot Steve.

I'll check your solution out. Anyway, it's rather odd, 'cause i remember loading xmldocument and before pushing it into msmq message, saved it into xml file again...

Seems like we've reached a dead end concerning this topic...

Thanks stevefromOZ, but if you check again the code i've posted, it belongs to a script task that i'm using to send messages to a remote private queue... As far...

Thanks for the help stevefromOZ.

Anyway, as i said in my previous post, i'm sure i can load xmldocument in the intended encoding, "ISO-8859-1". My xml messages are generated with the...

So, no thoughts on this one?

Ok Guys...

After some research, i've chosen the Messaque Queue Task approach (i'm more confortable with SSIS than Sql Broker's EA).

I've already implemented the necesssary line codes in order to...

Thanks for your replies RBarryYoung,

Before anything else, hope to hear from your good recovery soon...

I'll will search further into some External Activator implementations and at the same time take a...

Thanks for the replies!

RBarryYoung, External Activator - featured inside Service Broker - seems one of the rightest but not the easiest approach... SSIS Message Queue Task shouldn't get the job...

Thanks for the help Gift Peddie,

I will try to explain better what i intend to do. Maybe i'm going in the wrong direction and perhaps you can point me out...