calling stored procedure in another stored

-- create temporary table to store the result
IF OBJECT_ID('tempdb..#result')
   DROP TABLE #result
CREATE TABLE #result
   (
   datefrom  DATETIME NULL,
   dateto    DATETIME NULL,
   accountId INT      NULL
   )

-- insert from first proc
-- NOTE columns must in the same order as the proc result
INSERT INTO #result
   (
   datefrom,
   dateto,
   accountId
   )
EXEC firstProcedure @param1,@param2 -- replace with your procedure name and parameters

-- insert from second proc
-- NOTE columns must in the same order as the proc result
INSERT INTO #result
   (
   datefrom,
   dateto,
   accountId
   )
EXEC secondProcedure @param1,@param2 -- replace with your procedure name and parameters

-- final result
SELECT  *
FROM    #result