逻辑难题，求大神帮助，最后的分数献下，做完好回家过年(2)

                                        1
                                 FROM   dbo.DP_CommonSmsEntries DCSE
                                 WHERE  DCSE.RecvTime >= @BeginTime
                                        AND DCSE.RecvTime < @EndTime
                                        AND DCSE.CorpId = @Corpid
                                        AND DCSE.Instruction = 'XS'
                                        AND DCSE.MemberId = tt.MemberId ) 
                                        
--排除休假会员              
                                        AND NOT EXISTS ( SELECT TOP 1
                                        1
                                 FROM   DP_SysAttendanceEntries dsae
                                 WHERE  dsae.AttendDate >= @BeginTime
                                        AND dsae.AttendDate < @EndTime
                                        AND dsae.CorpId = @Corpid
                                        AND tt.MemberId = dsae.MemberId