CREATE PROCEDURE GetMemberManagement @UserId varchar(100) AS BEGIN declare @membertype varchar(100) set @membertype= CAST((select b.membertypename from users a left join membertypes b on a.membertype=b.membertype where a.userid = @UserId) if @membertype = 'Advisor' BEGIN select b.fullname,c.membertypename,a.rankno,d.rankname from users a left join profiles b on a.accountid=b.accountid left join membertypes c on a.membertype=c.membertype left join ranks d on a.rankno=d.rankno where a.userid=@UserId END else if @membertype = 'Agent' BEGIN select b.fullname,c.membertypename,a.rankno,d.rankname from users a left join profiles b on a.accountid=b.accountid left join membertypes c on a.membertype=c.membertype left join ranks d on a.rankno=d.rankno where a.userid=@UserId END END
CAST
... set @membertype= CAST( (select b.membertypename from users a left join membertypes b on a.membertype=b.membertype where a.userid = @UserId) as varchar(100)) ...
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)