How to Share Data Between Stored Procedures

How to Share Data Between Stored Procedures
http://www.sommarskog.se/share_data.html

Using OUTPUT Parameters

Table-valued User-defined Functions

Using a Table

Insert-Exec

Table Parameters, and Table Types

Using the CLR

OPENQUERY

Using XML

Using Cursor Variables

A must read.