Popular Posts

  • Network Issue or THREADPOOL waits?
    SQLServerCentral.com Articles Network Issue or THREADPOOL waits? Tara Kizer talks identifying THREADPOOL waits and what you can do ...
  • SQL Server Management Studio add-ins
    SQLServerCentral » Latest topics SQL Server Management Studio add-ins Comments posted to this topic are about the item [B] SQL Serv...
  • The Most Wanted Upgrade
    SQLServerCentral » Latest topics The Most Wanted Upgrade Comments posted to this topic are about the item [B] The Most Wanted Upgra...

SQLblog.com - The SQL Server blog spot on the web

Loading...

Tuesday, July 4, 2017

Case statement - Count When

SQLServerCentral » Latest topics
Case statement - Count When
Hi
I am trying to add in the case statement below 
if sn_status <> 'COMP' and sn_type='De-Activated' then 'NOT COMP'
Could you tell me how I could incorporate that?
Thanks
Dani
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)