6
Reply

How to use condition for row invisible and visible

mukesh55965 .

mukesh55965 .

May 10 2017 3:01 AM
334
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)