Select distinct * into #Temp_table from Original_table

Truncate table Original_table

insert into Original_table

select * from #Temp_table

declare @BDate datetime = '01 jan 1990'

select DATEDIFF(yy,@BDate, getdate()) as AgeInYears, DATEDIFF(mm,@BDate, getdate()) as AgeInMonths, DATEDIFF(WW,@BDate, getdate()) as AgeInWeeks

If you have a relation/common columns in a different tables, you can use joins in your query to get the result.

You cannot capture more than 1 result set into different tables tables.

Without change the SP, you cannot port those tables into different tables. Or ge the readonly crediential for that DB and get the table details.