DECLARE @t0 decimal(2,0),--excelden gelecek parametreler @t1 nvarchar(4000),--excelden gelecek parametreler @t2 nvarchar(4000),--excelden gelecek parametreler @t3 nvarchar(4000),--excelden gelecek parametreler @t4 nvarchar(4000),--excelden gelecek parametreler @t5 nvarchar(4000),--excelden gelecek parametreler @t6 nvarchar(15), --excelden gelecek parametreler @t7 nvarchar(15) --excelden gelecek parametreler DECLARE test_nebim CURSOR FOR SELECT [dfCompanyMarkup].[CompanyCode] ,[dfCompanyMarkup].[DiscountTypeCode] ,[dfCompanyMarkup].[ProductGroupLevel01] ,[dfCompanyMarkup].[ProductGroupLevel02] ,[dfCompanyMarkup].[ProductGroupLevel03] ,[dfCompanyMarkup].[CreatedUserName] ,[dfCompanyMarkup].[LastUpdatedUserName] FROM dfCompanyMarkup --***** EXCELDEN AKTARILAN TABLOLAR******* OPEN test_nebim; FETCH NEXT FROM test_nebim INTO @t0,@t1,@t2,@t3,@t4,@t5,@t6 -- Check @@FETCH_STATUS to see if there are any more rows to fetch. WHILE @@FETCH_STATUS = 0 BEGIN exec sp_executesql N'INSERT INTO [dfCompanyMarkup_Y] ([dfCompanyMarkup].[CompanyCode] ,[dfCompanyMarkup].[DiscountTypeCode] ,[dfCompanyMarkup].[ProductGroupLevel01] ,[dfCompanyMarkup].[ProductGroupLevel02] ,[dfCompanyMarkup].[ProductGroupLevel03] ,[dfCompanyMarkup].[CreatedUserName] ,[dfCompanyMarkup].[LastUpdatedUserName] ) VALUES (@p0 -- CompanyCode , @p1 -- DiscountTypeCode , @p2 -- ProductGroupLevel01 , @p3 -- ProductGroupLevel02 , @p4 -- ProductGroupLevel03 , @p5 -- CreatedUserName , @p6 -- LastUpdatedUserName ) SELECT @@ROWCOUNT ',N'@p0 decimal(2,0),@p1 nvarchar(4000),@p2 nvarchar(4000),@p3 nvarchar(4000),@p4 nvarchar(4000),@p5 nvarchar(7),@p6 nvarchar(7)',@p0=@t0,@p1=@t1,@p2=@t2,@p3=@t3,@p4=@t4,@p5=@t5,@p6=@t6 FETCH NEXT FROM test_nebim INTO @t0,@t1,@t2,@t3,@t4,@t5,@t6 END CLOSE test_nebim; DEALLOCATE test_nebim;
