I am trying to loop through my counter to create a dynamic sql query which should fin

[Anusrivastava]

I am trying to loop through my counter to create a dynamic sql query which should finally look like

I am trying to use this approach to get the final query but doesnt seems to work

declare @CurrentRow int
set @CurrentRow =0;
declare @RowsToProcess int
declare @FinalHistoricalQuery varchar(5000)
WHILE @CurrentRow<3
BEGIN      
   SET @FinalHistoricalQuery =' select 11'+convert(varchar(20),@CurrentRow) + ' union '
   SET @CurrentRow=@CurrentRow+1
END
 
SET @FinalHistoricalQuery = left(@FinalHistoricalQuery,len(@FinalHistoricalQuery)-6)
exec (@FinalHistoricalQuery)

the final ouput that i am looking for is 110 111 112 but it comes as 112 Any suggestion would be helpfull

[Rabbit]

Please use code tags when posting code or formatted data.

The problem is that you keep replacing the value of the variable instead of appending to it. You are doing x = new value instead of x = x + new value