Hi

Is it true that LLBL "retrieval" stored procedures can only be created from stored procedures selecting from a physical table?

I have had problems with LLBL recognising SPs as retrieval procedures when the final select in the SP is from an sqlserver 200 temporary #table.

Any ideas?

Thanks Mark

That's an issue with sqlserver. You should go into the catalog explorer, look up the procedure, click open the procedure node and browse to the #0 node. Select it, click with the Right mouse button on it and select the context menu option to change the value. Change it to 1 or 2. After that you'll be able to add the procedure as a retrieval procedure.

Thanks very much for your help (again!)

Mark

Thanks very much Frans..