SQL WHILE LOOP Example

Here i describe how to use while loop in SQL  Server

 

declare @datefrom datetime,

@dateto datetime ,

@Datevar datetime

select @datefrom=MIN(ActiveDate),@dateto=MAX(ActiveDate) from #tmpClients

set @Datevar=@datefrom

while @Datevar<=@dateto

Begin

//--Code here ---

select @Datevar

SET @Datevar =   dateAdd(dd,+1,@Datevar)

end