Execute the following Microsoft SQL Server Transact-SQL script in Management Studio Query Editor to demonstrate the creation of integer and date series with the use of the multiple-value assignment operator within an UPDATE statement. The construct avoids the use of cursor WHILE loop, therefore it is a scalable solution.

use tempdb;

select ID = CONVERT(int,SalesOrderID),

TestDate=convert(date,ModifiedDate) into DateSeries

from AdventureWorks2008.Sales.SalesOrderHeader

go

select top 100 * from DateSeries

go

-- Multi-value assignment UPDATE

declare @Date  date = dateadd(day,1,getdate()), @id int = 0

update DateSeries

set @id = ID = @id + 1,

    @Date = TestDate = dateadd (Day, -1, @Date)

go

select top 100 * from DateSeries

go

use tempdb;

drop table DateSeries

go

First and second partial results: