I have a stored procedure in sybase and I want to run it with two different parameters in a new stored
procedure and return the total of both the stored procs in this new stored procedure. e.g. I have a stored proc sp1 that i have to run with 2 different parameters i.e run first time sp1 with parameter A=1 which will return 20 records and then I will run sp1 with parameter A=2 which will return 30 records, now I want to store these values somewhere and return 50 records in my new stored proc.
Can somebody please help?