Fill a dynamic table

Thanks I did it this my procedure statement:

	DECLARE @weeks_ordered TABLE (num VARCHAR(7)) 
	DECLARE @weeks TABLE (wk VARCHAR(10)) 
	--DECLARE @DATE DATETIME 
	DECLARE @cols NVARCHAR(3000) 
	DECLARE @INT VARCHAR(1000) 
	DECLARE @col_pv VARCHAR(2000) 
	DECLARE @query VARCHAR(3000) 

        DECLARE @debut as smalldatetime
        DECLARE @fin   as smalldatetime

SET @debut='01/01/2009'
SET @fin='01/12/2009'

	/*****************Periods************************/
	  
	SET @INT = '200901'
	--SET @DATE = GETDATE() 
	  
	WHILE @INT <= cast(CONVERT(char(6),@fin, 112)as NVARCHAR(100))
	BEGIN 
	    SET @INT = cast(CONVERT(char(6),@debut, 112)as NVARCHAR(100))
		INSERT INTO @weeks VALUES (@INT) 
	   	set @debut=DATEADD(month,1,@debut)  
	END 

/*********************************************************/

	SELECT @col_pv = STUFF(( SELECT   
	                                '],[p'  + p.wk
	                        FROM  @weeks AS p 
	                        FOR XML PATH('') 
	                       ), 1, 12, '') + ']'  
   SELECT @cols = STUFF(( SELECT   
	                                '],[p'  + p.wk
	                        FROM  @weeks AS p 
	                        FOR XML PATH('') 
	                       ), 1, 12, '') + ']'
	
IF OBJECT_ID('tempdb.dbo.#detail') IS not null 
	        DROP TABLE #detail 
	  
	CREATE TABLE #detail 
	( 
	Client VARCHAR(20) 
	,Nom VARCHAR(50)
	,"Id Commercial" VARCHAR(100)
	,Agence Varchar (100) 
	,Montant DECIMAL 
	,Period varchar(100)
	) 
	  
  
	INSERT INTO #detail 
	SELECT 
		 hdr."Sell-to Customer No_"  Client
		,hdr."Bill-to Name" Nom
		,cast( commercial."Name" as varchar(100))  As "Id Commercial"
		,'Agence'=CASE
				WHEN 
				commercial.NomCommercialDistrib='' and commercial.NTiersCommercialDistrib=''
				THEN commercial.NomRegroupement
				WHEN 
				commercial.NTiersCommercialDistrib='' and commercial.NomCommercialDistrib<>''
				THEN commercial.NomRegroupement+'#'+ commercial.NomCommercialDistrib
				WHEN 
				commercial.NomCommercialDistrib='' and commercial.NTiersCommercialDistrib<>'' 
				THEN commercial.NomRegroupement+'/'+ commercial.NTiersCommercialDistrib

				else commercial.NomRegroupement+'/'+ commercial.NTiersCommercialDistrib+'#'+ commercial.NomCommercialDistrib
				END 
	    ,hdr.Montant Montant
	    ,'p'+cast(CONVERT(char(6),hdr."Shipment Date", 112)as NVARCHAR(100)) Period 
	
FROM 
	dbo."CORIOLIS_V1$Sales Invoice Header" hdr 
	INNER Join @weeks ord ON cast(CONVERT(char(6),hdr."Shipment Date", 112)as NVARCHAR(100)) = wk 
	,dbo."CORIOLIS_V1$Salesperson_Purchaser" commercial
	,dbo.CORIOLIS_V1$Subcontract subcont
	WHERE 
		subcont."Customer No_"=hdr."Sell-to Customer No_"
		and commercial.Code=subcont.Salesperson

	GROUP BY 
			 hdr."Sell-to Customer No_"
			,hdr."Bill-to Name" 
			,subcont."Salesperson"
			,commercial."Name"
			,commercial.NomRegroupement
			,commercial.NTiersCommercialDistrib
			,commercial.NomCommercialDistrib
			,hdr.Montant
			,cast(CONVERT(char(6),hdr."Shipment Date", 112)as NVARCHAR(100))
			,wk 
	
ORDER BY Client

	  
	SET @query = 
	' 
	Select  
	    Client
		, Nom
		, "Id Commercial"
		, Agence
		, '     + @cols+ ' 
	From 
	    #detail  
	PIVOT (sum(Montant) FOR Period IN (' + @col_pv + ')) as pv 
	Order By Client
	' 
	EXEC(@query)