other way to make progress bar for each 10% only

declare

@max-2 decimal(10,3)

, @CNT decimal(10,3)

, @ProgressBar varchar(250)

, @Percentage int

, @PercentageStep int

set @max-2 = 8745.458

set @CNT = 1.0

set @PercentageStep = 10

WHILE @CNT <= @max-2

BEGIN

Set @CNT = @CNT + 1

IF ((@CNT*100/(ceiling(@MAX/@PercentageStep)*@PercentageStep)) % @PercentageStep) in ( 0.00)

BEGIN

set @Percentage = @CNT*100/(ceiling(@MAX/@PercentageStep)*@PercentageStep)

set @ProgressBar = replicate('X',@Percentage/2)+' '+ltrim(rtrim(str(@Percentage)))+' '+replicate('_',(100-@Percentage)/2)

raiserror(@ProgressBar, 0, 1) with nowait

END

END