Hi Raj,
As per your requirement you can use Table variable or Temporary table for Storing Output Data .
Eg :
Select * into #temp from Employee
Above Query Create Temporary table #temp and Stores output from Employee into #temp table
Now when you want to use stored data, you can just write select Query as :
Select * from #temp
Cheers !
Yogendra Dubey