Stored Procudure to insert a set of records with a just one Column value being

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

No comments: