Select And Then Inserting Results Into Two Different Tables

Hello!


I've got the following procedure:


ALTER PROCEDURE [GetTimeDiff2] (@ID int) AS


select


A_ProspectPipeline.ID,


(case when [Completion Date] is null


then '13'


else


case when YEAR([Completion Date])>year(GETDATE())


then '13'


else


case when YEAR([Completion Date])<year(GETDATE())


then '1'


else month([Completion Date])


end


end


end)-


(case when YEAR([Start Date])=year(GETDATE())


then month([Start Date])


else


case when YEAR([Start Date])<year(GETDATE())


then '1'


else '13'


end


end)as [CY],





(case when [Completion Date] is null


then '13'


else


case when YEAR([Completion Date])>year(GETDATE())+1


then '13'


else


case when YEAR([Completion Date])<year(GETDATE())+1


then '1'


else month([Completion Date])


end


end


end)-


(case when YEAR([Start Date])=year(GETDATE())+1


then month([Start Date])


else


case when YEAR([Start Date])<year(GETDATE())+1


then '1'


else '13'


end


end)as [NY]





from a_ProspectPipeline where A_ProspectPipeline.ID = @ID





What i need to do is insert the two returned values [NY] + [CY] into two different tables.


Can anyone help me with this?