Create Procedure [dbo].[P_transfer_photo_test]

(

	@Month_id Varchar(6)

)

As

Begin

	

	Declare @Sql Varchar(4000)

    

	Create Table #Fact_Temp_POP_User_Raw_Data(

                                Raw_id int identity(1, 1),

                                Data_id int NULL,

								Submit_Date varchar(50) NULL,

                                User_id int NULL,

                                POPDB_id int NULL,

								Chain_Group_id int NULL,

								Chain_id int NULL,

								Channel_id int NULL,

								Client_POP_id varchar(50) NULL,

								POP_Name varchar(500) NULL,

								POP_Address varchar(1000) NULL,

								Source_Type varchar(50) NULL,

								Task_Group varchar(1000) NULL,

								Category_id int NULL,

								Subcategory_id int NULL,

								SKU_Cluster_id int NULL,

								Brand_id int NULL,

                                SKU varchar(500) NULL,

                                Quest_Task varchar(500) NULL,

                                Data_SubTask varchar(500) NULL,

                                Subtask_Value varchar(1000) NULL,

                                Subtask_Type varchar(1000) NULL,

                                City_id int NULL,

                                District_Value varchar(50) NULL,

                                Region_Value varchar(50) NULL,

                                Area_Value va