Eugene Elutin (5/8/2013)

---

Actually you can, if you really want or need to!

You should use cursor datatype in output parameter of your procedure. Here you will find a sample:

http://msdn.microsoft.com/en-GB/library/ms175498(v=sql.105).aspx

Should, also mention that this technique is not used very often...