Вычисляемый столбец

CREATE TABLE [dbo].[Candidate](
    [ID] [int] IDENTITY(1,1) NOT NULL,
    [FacultyID] [int] NOT NULL,
    [Course] [int] NOT NULL,
    [FIO] [varchar](255) NOT NULL,
    [SpecialtyUOID] [int] NOT NULL,
    [YearSet] [smallint] NOT NULL,
    [Statement] [date] NULL,
    [Questionnaire] [bit] NULL,
    [CopyPassport] [bit] NULL,
    [CopyPripis] [bit] NULL,
    [Characteristic] [bit] NULL,
    [AverageMark] [float] NULL,
    [CertificateVVK] [bit] NULL,
    [Active] AS (case when [Statement] != NULL then
                     case when [Questionnaire] = 1 then
                         case when [CopyPassport] = 1 then
                             case when [CopyPripis] = 1 then
                                case when [Characteristic] = 1 then
                                    case when [AverageMark] != NULL then
                                        case when [CertificateVVK] = 1 then
                                            CONVERT([bit],(1))
                                        else CONVERT([bit],(0)) end 
                                    else CONVERT([bit],(0)) end 
                                else CONVERT([bit],(0)) end     
                             else CONVERT([bit],(0)) end 
                         else CONVERT([bit],(0)) end 
                     else CONVERT([bit],(0)) end 
                else CONVERT([bit],(0)) end)
 CONSTRAINT [PK_Condidate] PRIMARY KEY CLUSTERED 
(
    [ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

[Statement] IS NOT NULL

cast(case when [Statement] is not null and [Questionnaire] = 1 and [CopyPassport] = 1 and [CopyPripis] = 1 and [Characteristic] = 1 and [AverageMark] is not null and [CertificateVVK] = 1 then 1 else 0 end as bit)