query to count unread records from ms sql

Question

can any one help to write or give idea of how write a query in ms sql to count unread records.