hey all thanks for your help, managed to find APEX sql clean which looks promising.

Thanks guys for your input. I guess I would be not only after selected columns but all columns including ones used internally.

I found this article that may help?

http://www.sqlservercentral.com/articles/Administration/3214/

thankyou - so bascially I need to do a query on this view, which will map the stored procedure (depid) to the id (object - is this a table or...

Hi there - thanks for the reply

Most are just select statements in stored procedures, that are presented through ssrs and ms access

My bad, sorry about that, will get onto creating some sample data.

And yes that looks good