I have three stored procedures that return the same columns (StartDate, EndDate, Duration). I need to merge the results of these three stored procedures into a single result set, but I cannot figure out how to accomplish this goal. I created a new stored procedure "XXX", which will be called by a report. I've tried to select against a stored procedure, but it failed. I've done some research and discovered that I should use EXEC to invoke a stored procedure and return the result set, but... I cannot figure out how to merge all 3 stored procedures result sets into a single one that is returned by the new stored procedure, XXX. I would really appreciate your help...