I was just wondering if it makes sense that for all the select statements that I have in the SP to create views can use them in the same SP.

...

Thank you Steve.

You are great! I am running SQL7, hoping to upgrade in the near future to SQL2000 🙂

It's a web application with, lets say it, 12 orderheaders. The requirement is that after the header to display also the details. (something like: header,detail,header,detail,etc.) So I made a join...

Thanks!

But I can't use the ID because the records that I want to extract are already from a select statement from a table.

What if a parse the table each time...

Thanks very much. You helped me a lot.

First time DTS, so... sorry!

Radu