I agree that i would be easier to build the the app but it was just to slow. By using a procedure I cut the execution time from 4-5 minutes to apx 20 seconds. The stored procedure I created runs fine but it needs some flexibility. One thing it needs to be able to do is to change from an inner to a left outer join if a paramteter is passed or add a piece to the where clause if necessary. What I want to avoid is haveing multiple procedures called from one button (that only gets a cursor for a report).