insert into #worktest (empid,jobid,startdate,enddate) values (1,2,'2002-05-15','2002-06-01') insert into #worktest (empid,jobid,startdate,enddate) values (1,3,'2004 ...
I think you can now get the t-sql equivalent of Oracle's materialised views. If so, then you may be able to keep the table in the original format (with ordering field) and use a materialised view to ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback