Posted by David Portas on 07/24/05 10:56

It's a long time since I used Crystal. Are you certain it can't call a proc?
It might be worth seeking some help on the Crystal side first.

A function can't call a proc but I expect you can rewrite your proc as a
function or a view. Contrary to what it might seem there are usually ways to
do things without temp tables and if not you can often use table variables
instead. If you need more help, please post DDL, sample data and required
results: http://www.aspfaq.com/etiquette.asp?id=5006

--
David Portas
SQL Server MVP
--

[Back to original message]