Home Forums Article Discussions Article Discussions by Author Discuss content posted by Jack Corbett Who has accessed my 2005 server? RE: Who has accessed my 2005 server?

  • April 4, 2013 at 3:56 am

    #1603478

    Hi,

    I do not like "NULL" value in results.

    May I suggest this :

    ...

    CASE

    when S.type_desc is NULL then 'allowed via a Windows Group'

    else S.type_desc

    end as type_desc,

    ...

    🙂