All, I have a table with similar values to this: 

```
Name    Value   Server time
a   None    3/17/2016 11:59:50 PM
a   None    3/17/2016 11:59:36 PM
a   None    3/17/2016 11:59:33 PM
a   March Madness   3/17/2016 11:59:33 PM
a   None    3/17/2016 11:59:19 PM
b   TGIF    3/17/2016 11:59:04 PM
b   None    3/17/2016 11:58:44 PM
b   March Madness   3/17/2016 11:58:29 PM
b   None    3/17/2016 11:58:22 PM
c   None    3/17/2016 11:58:17 PM
c   None    3/17/2016 11:58:15 PM
c   None    3/17/2016 11:58:14 PM
c   None    3/17/2016 11:57:50 PM
c   None    3/17/2016 11:57:33 PM

```

My result set should be this:

```
a   March Madness
b   TGIF
c   0

```

So in other words, I should get the latest value sorted by ServerTime that is not 'None' and when I just have 'None' it should be zero

Thanks in advance