Hi Paulhumphris

I'm afraid I don't have access to that tool, can you tell me how to do this or the source where I can get it?

Tnks very much

Thank you Greg,

Your suggestion makes sense to me, I'll do some tests to see the results,

regards

quote:

---

To...

I tried that but it didn't retrieve good performance results 'cause I'm using tempdb anyway and by other hand the parameter @params is dinamic so I have to...

thank you for your point of view sjcsystems, I understood your suggestions about float data type, usually we receive information with 4 decimals and I think this point doesn't matter.

...

I'm using a extended procedure because the information we need is retrieved from a DLL of one of our data sources, that is why we use the XP.

greetings

Engineer Programmer Jr.

Edited...

hi sjcsystems

I saw your suggestions and I have some questions for you, in your first point of view, the performance could be affected using table variable type if the result...

In the case that due to consulting and computing values its not possible to use a permanent table, what other option would I have??

Omar

Engineer Programmer Jr.