Hi,

I have a sp that returns a list of customers whose status=5
such as
select customerid from customers where status=5

I want to run a second sp that will call the first sp but will return the cumstomerids that are bigger than 5 for example.

The result could return many rows.

Is there a way of doing it?

Thanks

I only know one way to do this. Your 2nd sp would need to so this:
1. create a temp table to hold the results of the 1st sp
2. run the 1st sp, putting the results into the temp table - you can use the syntax INSERT #temptable EXEC yoursp @param1, ...
3. run a query against the temp table to only return the customers you want.

rgds
Phil