MyException - 我的异常网
当前位置:我的异常网» Sql Server » 逻辑难题,求大神帮助,最后的分数献下,做完好回家

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

www.MyException.Cn  网友分享于:2013-02-21  浏览:7次

                                        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

文章评论

软件开发程序错误异常ExceptionCopyright © 2009-2015 MyException 版权所有