I need to insert rows in worksheet with a specific format to be loaded to sql server. This is code in Sql server that needs to be
DECLARE @LoopCounter INT = 1 WHILE ( @LoopCounter <= 17) BEGIN INSERT INTO [dbo].[Load_RCM_OS2_Mtg_Daily_Report] ([Sample Number] ,[Reporting Transit] ,[QuarterYear] ,[PC Code] ,[Report Date] ,[Transit Tested] ,[date_loaded] ,Snap_Dt) VALUES (@LoopCounter,3753,32020,NULL,NULL,NULL,'2020-04-30','2020-04-30') SET @LoopCounter = @LoopCounter + 1 END
How to duplicate the rows in Datameer. I created one row in Sheet1 manually but need help in repeating it 17 times
Please sign in to leave a comment.