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.