S
Scott
Can someone off me some starting air code for the following?
How do I have a stored procedure send a return value,
then have my code capture the result?
Here's what I'm trying to do... in a form's code, I need to check if a
user is a member of a permissions group.
I can call a stored procedure that uses this T-SQL:
IF (IS_MEMBER('CRRR\HR-AllAccess') = 1)
Begin
--The user is a member
End
Else
Begin
--The user is not a member
Else
What is the T-SQL to fire back the result... and how do I capture that
value in code?
Thanks in advance!
How do I have a stored procedure send a return value,
then have my code capture the result?
Here's what I'm trying to do... in a form's code, I need to check if a
user is a member of a permissions group.
I can call a stored procedure that uses this T-SQL:
IF (IS_MEMBER('CRRR\HR-AllAccess') = 1)
Begin
--The user is a member
End
Else
Begin
--The user is not a member
Else
What is the T-SQL to fire back the result... and how do I capture that
value in code?
Thanks in advance!