将联合POC结果插入电话

Question

我想更改一个proc，这样我就可以将结果插入到表中。你能给我带路吗？谢谢。。

   ALTER proc [dbo].[usp_CtotalPPPP]
   AS
   BEGIN 
   SELECT   CID, Consumer1, Consumer2, datepart(year, getdate()) Year, 'Jan'  Month, [Jan_S] Budget, [JanAct] Act, getdate() 
         FROM            CProgramDetails
   UNION
   SELECT   CID, Consumer1, Consumer2, datepart(year, getdate()) Year, 'Feb' Month, [FEBOCV_Spend] Budget, [FEBAct] Act, getdate() 
        FROM            CProgramDetails
   UNION
   SELECT CID, Consumer1, Consumer2, date part(year, getdate()) Year, 'Mar' Month, [MarOCV_Spend] Budget, [MarAct] Act, getdate() 
        FROM            CProgramDetails
 UNION
 SELECT  CID, Consumer1, Consumer2, datepart(year, getdate()) Year, 'Apr' Month, [AprOCV_Spend] Budget, [AprAct] Act, getdate() 
        FROM            CProgramDetails
 INSERT INTO [dbo].[ABCD123] (---this is failing - I do not know where to add this)

End