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_DalRep] ([SamNum] ,[RepTR] ,[QuarterYear] ,[PCC] ,[RepDate] ,[TrDate] ,[DTloaded] ,MthEnddate) 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.