CODEWITHSUNDEEP
sql-servercalculated-columns
Alexandre
Alexandre

Reputation: 13318

Calculated field in Sql Server 2008

create proc PrAspnet_RolesGet
as

select  r.RoleId, r.RoleName, lr.RoleId as IsLoginetRole
from aspnet_Roles r

left join loginetRoles lr
on r.RoleId = lr.RoleId

The table loginetRoles contains one field - the RoleId. How can I replace the field IsLoginetRole from Guid value to bit value?

Upvotes: 0

Views: 371

Answers (1)

Martin Smith
Martin Smith

Reputation: 453807

SELECT r.RoleId,
       r.RoleName,
       CAST(CASE
              WHEN lr.RoleId IS NULL THEN 0
              ELSE 1
            END AS BIT) AS IsLoginetRole
FROM   aspnet_Roles r
       LEFT JOIN loginetRoles lr
         ON r.RoleId = lr.RoleId

Upvotes: 3

Related Questions