CREATE TABLE [dbo].[Table_2]( [Order] [int] IDENTITY(1,1) NOT NULL, [thickCase] [bit] NULL, [thick_Case] AS (case [thickCase] when NULL then 'Fixed' else case [thickCase] when (1) then 'Up' else 'Down' end end), CONSTRAINT [PK_Table_2] PRIMARY KEY CLUSTERED ( [Order] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO
[thick_Case] AS (case [thickCase] when NULL then 'Fixed' else case [thickCase] when (1) then 'Up' else 'Down' end end)
[thick_Case] AS ( CASE WHEN COALESCE([thickCase], -1) = 1 THEN 'Up' WHEN COALESCE([thickCase], -1) = 0 THEN 'Down' ELSE 'Fixed' END ),
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)