CREATE TABLE [dbo].[chapter_report]( [qno] [int] NULL, [chapter] [varchar](max) , [Topic] [varchar](max) , [Status] [bit] NULL)
case
select distinct(case when status =1 chapter else 0 end from chapter_report
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)