Loop in MS-SQL

 DECLARE @Counter INT 

SET @Counter=1

WHILE ( @Counter <= 2032)

BEGIN

insert into gudangBMN.dbo.transaksi(idTransaksiToga,status,tglRekam,keterangan) values (newid(),'Masuk',getdate(),'Keterangan 1')

    SET @Counter  = @Counter  + 1

END