Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
-- Copy
select top 150 *
into #tmp_tpoints
from tpoints
order by date desc
select A.*
into #tmp_tauto
from tauto A
join #tmp_tpoints P on P.id = A.id --assuming it's the join
-- Carefuly check you get what you want
select * from #tmp_tpoints
select * from #tmp_tauto
-- Empty the tables
truncate table tpoints
truncate table tauto
-- Copy back
insert into tpoints select * from #tmp_tpoints
insert into tauto select * from #tmp_tauto
-- Clean up
drop table #tmp_tpoints
drop table #tmp_tauto