i am using a view which fetches some lacs of records. i need to run this view at regular intervals of time i.e. for every one hour to send the data to other data base.
there are 3 base tables in that view.all these base table are having timestamp field.
now, it is becoming very difficult to fetch lacks of records for every one hour. so i want to modify this view. now i want to fetfch only modified records or newly inserted records in the last one hour.
is this possible by using the timestamp field of base tables and the view only or is there any better way.
the simple form of my view looks like this
CREATE View [dbo].[GetData] AS
from student std,department dept,marks m
where std.deptid = dept.deptid
and std.studentid = m.studentid
thans in advance.