DECLARE @list VARCHAR(1000)
SET @list = (SELECT STUFF((SELECT ',' + CHAR(39) +LoweredRoleName + CHAR(39)
FROM dbo.aspnet_Roles
WHERE LoweredRoleName NOT IN('expired','admin')
FOR XML PATH('')),1, 1, '') AS RolesCSV)
SELECT @list
SELECT
A.LoweredEmail,
D.RoleName
FROM dbo.aspnet_Membership AS A WITH (NOLOCK)
INNER JOIN dbo.aspnet_Users AS B WITH (NOLOCK) ON A.UserId = B.UserId
INNER JOIN dbo.aspnet_UsersInRoles AS C WITH (NOLOCK) ON B.UserId = C.UserId
INNER JOIN dbo.aspnet_Roles AS D WITH (NOLOCK) ON C.RoleId = D.RoleId
WHERE D.RoleName IN (@list)
WHERE D.RoleName IN (@list)
This does not get a result, but manually it works, like 'role1','role2', etc
I need to work with @list , any ideas !
...
Go to the complete details ...