Mukesh

Mukesh

  • NA
  • 228
  • 42.7k

How to use condition for row invisible and visible

May 10 2017 3:01 AM
SELECT uniquiID,
CountryFlag,
EventImage
,CONVERT(varchar(50), StartDate) as StartDate
,CONVERT(varchar(50), EndDate) as EndDate
,EventName
,Description
,CountryCode
,Remark
,Flag
FROM TradefairData
 
this my table-
and my flag column value is -   Null
                                                   0
                                                   1
                                                   Null
                                                   0
                                                  1
 
Then i Want to Know how to Use case when flag=1 then 3rd and 6th row invisible when flag=0 then all row visible else all row visible please help me
 uniquiID is my uniqueId Column
 
 

Answers (6)