This is what I did.

I am sure there is more efficient way to do this though.

if object_id ('tempdb..#Temp') is not null

drop table #temp

if object_id ('tempdb..#Temp1') is not null

drop table #temp1

if...

I thought it worked but it didn't. I used cross apply and then created two new temp table that didn't have time in the resulting table from cross apply, and...