SQLTeam.com | Weblogs | Forums

How to change the date on Every Monday, Tues and Wed

sql2008r2

#1

Hi,

I have table called Asset.

CREATE TABLE [dbo].[Asset](
	[Ast_No] [numeric](18, 0) NULL,
	[Ast_Date] [date] NULL,
	[Ast_Type] [nvarchar](50) NULL
) ON [PRIMARY]

GO

On Each Monday, Tues and Wed. i want to change the Ast_Date

Example On Monday evening i will put Tuesday date, Tuesday Evening Wednesday Date and Wednesday Evening Monday Date and it will repated respectively.

Thanks
Basit.