This method is not very elegant but it seems to work quickly.

select getdate()

Declare @sql int

set @sql=1

select @sql

while @sql<100

begin

set @sql=@sql+1

begin

if