Next, we need to unify SP 2 has a size pretty damn considerably. =)
Let the following scenario:
The Sp [A] has a SELECT with 10 tables with inner join and left.
Both [A] as [B] are very complex and require a legal use of the server.
Hence the question, I need a unified report of [A] and [B] ..
How best to run?