So how would I turn the above code into a stored procedure and get the info.

I have looked around several pages on google, but they all want to put the...