question

@technette It represents the column name of the result set of the stored procedure, which always returns one record. If the SessionsTable has the record satisfying the predicate then the sub-select will return 1 because max(1) = 1. If the table does not have the record for the specified SessionID then the result of the sub-select is null. Applying isnull to it guarantees that the procedure call will always return result in the form of one record one column (named SessionExists) with the possible values of either 1 or 0. This will make the stored procedure output consistent (almost like a boolean function):

exec CheckForSession 'bad_id';

-- result:
SessionExists
-------------
0

exec CheckForSession 'good_id';

-- result:
SessionExists
-------------
1

Raj, Thank you for responding. What does As "SessionExists" represent?

This is so kool! For my scenario We have a Session 'UserNumber' set here. The same user number is in a database table. I want to check the Session 'UserNumber' against the table 'UserNumber' and UserDivision.

Maybe I can simply use the data reader to check against the session variable that I retrieve: Dim UNUM As String = CType(Session.Item("UserNumber"), String) I created a stored procedure with a UserNumber as a parameter and returns a 1 if the conditions are met in the Where clause. ???