Thanks for the solution.

But, the restriction is 'without changing' the windows application. (I can imagine client's nightmare of installing new application if I use 'views' as per your solution). ...

My bad; I failed again to explain the problem; Let me try..

my_table (ordername varchar(50) ,

status varchar(1),

end_date datetime )

An inbound feed engine inserts data in 'my_table'. For ex: after...

Hi,

I over simplified the problem. The main problem is to call a stored procedure/trigger at 'specified time' (at exact datetime from my_table.eff_date ) just like scheduling a job...