Use the following stores Procedure to insert
CREATE procedure sp_insertBulk
as
-- SETUP RUNTIME OPTIONS / DECLARE VARIABLES --
declare @count int
SELECT @count=100
while (@count < 900) begin
INSERT INTO DV812.DBO.F00950 VALUES ('4','IC9017642','*ALL','MCU',' ' + convert(varchar,@count),
' ','CostCenter',' ',' ',' ',' ','Y','Y','Y','Y',' ' + convert(varchar,@count) ,
0,' ',' ',' ',' ',' ',' ',' ','IC9017642','EP00950','DENDS040',107234,72943.000000,0,0,0,' ')
SELECT @count =convert(int, @count) +1
end
GO
'SPACESHERE ' + convert(varchar,@count) is concatenating Spaces and the varchar equivalent of the count variable
How AI can enhance customer service
-
Virtual assistants with a conversational presence have been shown to
increase trust — and consequently also engagement — compared to purely
text-based chat...
4 hours ago