I am very new to creating stored procedures. I understand some of the basics. I need to select records based on a Session Variable. In my db teachers have a Teacher ID (TID) which is stored in Session as the variable TIDSession. I need to retrieve the variable and select records based on the TID. Is this possible? If so what would the code look like? I work in VB. Have VS2008 Pro, and Sql Server 2005.
Thank you for your assisstance.