lundi 18 juillet 2016

Insert SP data into two temporary tables

I have a SP whose data looks like below

SP

Now what I want is, I want to insert its data into two different temp table

First temp table will consist

`Doc_type`, `Doc_No`, and `No_of_days`

Second temp table will consist

Username, DocType, and No_of_days.

I tried like below

CREATE TABLE #table1 
            (
                Doc_type varchar(55),
                Doc_No varchar(55),
                No_of_days varchar(55),
            )
        INSERT INTO #table1 

But it is giving error as

Incorrect syntax near the keyword 'END'.

Here is my FULL SP

Alter procedure GET_INWARD_REMINDER_REPORT 
                AS 
        BEGIN 
                    Select
                    U.first_name + ' ' + U.last_name UserName, 
                    TH.User_ID, 
                    TY.Type_desc Document_Type, 
                    RA.mkey Reporting_To,
                    U.Email AS UserEmail, 
                    RAU.Email AS RA1_Email, 
                    RAU.first_name + ' ' + RAU.last_name RAName, 
                    TH.Doc_No, 
                    DATEDIFF(DAY,TH.LastAction_DateTime,GETDATE()) - DATEDIFF(WK,TH.LastAction_DateTime, GETDATE()) 
                    AS No_Of_Days_Doc_Pending 
                    from inward_doc_tracking_hdr TH 
                    inner join  
                    user_mst U ON TH.User_Id = U.mkey 
                    inner join 
                    emp_mst M ON M.mkey = U.employee_mkey 
                    inner join 
                    type_mst_a TY ON TY.master_mkey = TH.doc_type 
                    inner join 
                    emp_mst RA ON RA.mkey = M.Reporting_To 
                    inner join  
                    user_mst RAU ON RAU.employee_mkey = RA.mkey 
                        where 
                    TH.Status_flag NOT IN (5,14)  --- 5 for close, 14 for return
                    and TH.To_user IS NOT NULL 

                        CREATE TABLE #table1 
                        (   
                            Doc_type varchar(55),
                            Doc_No varchar(55),
                            No_of_days varchar(55),
                        )
                    INSERT INTO #table1 

END

Aucun commentaire:

Enregistrer un commentaire