Stored Proc With Varchar Output Parameter

Hi Guys


I am wondering if you could spare some time and help me out with this puzzle.


I am new to this stuff so please take it easy on me.





I’m trying to create procedure which will take 2 input parameters and give me 1 back.


Originally there will be more outputs but for this training exercise 1 should do.


There are 2 tables as per diagram below and what I’m trying to do is


Verify username & password and pull out user group_name.





|---------------| |-----------------------|


| TBL_USERS | |TBL_USER_GROUPS|


|---------------| |-----------------------|


| USERNAME | /|GROUP_ID |


| PASSWORD | / |GROUP_NAME |


| GROUP_ID |< | |


|---------------| |-----------------------|





For my proc. I am using some ideas from this and some other sites, but obviously i've done something wrong.





'====================================================


ALTER PROCEDURE dbo.try01


(


@UserName varchar(50),


@Password varchar(50),


@Group varchar Output


)


AS


SET NOCOUNT ON;


SELECT TBL_USERS.USERNAME, TBL_USERS.PASSWORD,@Group = TBL_USER_GROUPS.GROUP_NAME,


TBL_USERS.USER_ID, TBL_USER_GROUPS.GROUP_ID


FROM TBL_USERS INNER JOIN TBL_USER_GROUPS


ON TBL_USERS.GROUP_ID = TBL_USER_GROUPS.GROUP_ID


WHERE (TBL_USERS.USERNAME = @UserName)


AND (TBL_USERS.PASSWORD = @Password)


'====================================================








and this is what i'm getting in VS.Net while trying to save.








'====================================================


ADO error: A select statement that assigns a value to variable must


not be combined with data-retrieval operation.


'====================================================








I did not see any samples on the net using ‘varchar’ as OUTPUT usually they where all ‘int’s. Could that be the problem?





Please help.





CC