SELECT  COUNT(*)
 FROM    systemMessage a
 WHERE   EXISTS ( SELECT 1
                  FROM   ( SELECT TOP 10
                                     userid ,
                                     avid
                           FROM      ( SELECT DISTINCT
                                                 userid ,
                                                 avid
                                       FROM      Interactive
                                       WHERE     interResult IS NOT NULL
                                                 AND avid IS NOT NULL
                                                 AND CONVERT(VARCHAR(10), interdate, 120) = CONVERT(VARCHAR(10), GETDATE(), 120)
                                     ) i
                           ORDER BY  NEWID()
                         ) b
                  WHERE  a.userid = b.userid
                         AND a.avid = b.avid )