If you want to set your variables IsAdmin , IsSuperUser , and IsUser in one query, you can use the conditional aggregation like the following:

DECLARE @IsAdmin BIT, @IsSuperUser BIT, @IsUser BIT

SELECT
    @IsAdmin = MAX(CASE WHEN RoleId = 1 THEN 1 ELSE 0 END),
    @IsSuperUser = MAX(CASE WHEN RoleId = 3 THEN 1 ELSE 0 END),
    @IsUser = MAX(CASE WHEN RoleId = 5 THEN 1 ELSE 0 END)
FROM
    AspNetUserRoles
WHERE
    UserId = @CallerUserId

In this query, the MAX function is used with conditional expression ( CASE WHEN ) inside. Each conditional expression checks the RoleId and assigns either 1 or 0 based on the condition. The result of each one is then the aggregation using MAX to obtain a single value for each variable.

Note that the query assumes that the AspNetUserRoles table contains the columns RoleId and UserId , which are used for filtering the data. Adjust the table and column names as per your schema.

With no sample data I can't test this of course but you can aggregate, something like

select 
    @IsAdmin = IsNull(max(case when RoleId = 1 then 1 end),0)
    @IsSuperUser = IsNull(max(case when RoleId = 3 then 1 end),0)
    @IsUser = IsNull(max(case when RoleId = 5 then 1 end),0)
from #CallerRoles;