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]
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.