Union Of Multiple Procedures

Hi, i have encountered a problem in which i am sure has a simple answer. I am used to MySQL and am new to SQL Server and would appreciate any expert advice. Thanks

I have 4 stored procedures and need to get the data that they generate out of all of them and place them into one resulting table.

here is the code i had for it:

USE [SQLexport]
GO
/****** Object: StoredProcedure [dbo].[AllSpirometry] Script Date: 05/31/2007 17:05:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER PROCEDURE [dbo].[AllSpirometry] AS
BEGIN
select * from dbo.All05
UNION
select * from dbo.All075
UNION
select * from dbo.All01over6
UNION
select * from dbo.All075under6
END

and here are the errors that occurred:

Msg 208, Level 16, State 3, Procedure AllSpirometry, Line 3
Invalid object name 'dbo.All05'.
Msg 208, Level 16, State 3, Procedure AllSpirometry, Line 3
Invalid object name 'dbo.All075'.
Msg 208, Level 16, State 3, Procedure AllSpirometry, Line 3
Invalid object name 'dbo.All01over6'.

I have been told that this code will not work in SQL Server and been given a longggggg piece of code that will make it work by placing all data into a temporary table. I am adamant that such a long piece of code is not needed, surely there must be a way to get this to work very simply in SQL Server.

I would appreciate any help you can provide me, thanks