sp中的循环插入

USE [PwC.VAT]
GO

IF (EXISTS (SELECT * FROM SYS.OBJECTS WHERE name = 'proc_TaxFillingRevenueSide_Insert'))
 DROP PROC proc_TaxFillingRevenueSide_Insert
GO

CREATE PROC proc_TaxFillingRevenueSide_Insert
@Number BIGINT
AS 
DECLARE @N BIGINT,
        @SQL NVARCHAR(MAX) 
SET @N=0
WHILE @N<@Number
BEGIN
 SET @SQL='INSERT INTO [PwC.VAT].[dbo].[TaxFillingRevenueSide222] (
              [TaxRate]
              ,[TransactionDate]
              ,[InvoiceType]
              ,[TransactionNo]
              ,[InsuranceNum]
              ,[ClientNo]
              ,[TaxId]
              ,[IsOnCredit]
              ,[InvoiceNum]
              ,[IsRedInvoice]
              ,[IsCancelled]
              ,[IsDeducted]
              ,[TaxAmount]
              ,[TransactionAmount]
              ,[ClientType]
              ) 
            SELECT 
              0.06
              ,GETDATE()
              ,''S''
              ,''PA'' + CONVERT(varchar(8), GETDATE(), 112)
              ,''InsuranceNum''
              ,''ClientNo''
              ,''21138277464''
              ,1
              ,''InvoiceNum''
              ,0
              ,0
              ,0
              ,106/(1+0.06) *0.06 
              ,106
              ,''ClientType''' 
 EXEC (@SQL)  
 SET @N=@N+1
END
GO