How would you code a SP that returned some 700k+ rows.
Anonymous
Why on earth would you need to see so much data? Use a BI tool (data warehouse) to handle these types of requests. No user can absorb that amount of data.
Check out your Company Bowl for anonymous work chats.