Archive data in two queries

While working with T-SQL, many times we create complex queries, and then we might need to optimize them at some later...