SELECT    crn, admission,  admdate, admtime, disdate, admsource, admtype
FROM         mfCarlRepos.dbo.admissions as table_name1
WHERE     (admdate >= '2010-04-01' AND admdate <= '2010-08-31')

SELECT    crn, admission,  admdate, admtime, disdate, admsource, admtype
FROM         mfCarlRepos.dbo.admissions as table_name1
WHERE     admdate BETWEEN '2010-04-01' AND '2010-08-31'

SELECT    crn, admission,  admdate, admtime, disdate, admsource, admtype
FROM         mfCarlRepos.dbo.admissions as table_name1
WHERE  admdate BETWEEN ( Dateadd(dd, Datediff(dd, 0, Getdate()), 0) ) AND (
                       Dateadd(dd, -14,
                              (
                              Dateadd(dd, Datediff(dd, 0, Getdate()), 0) )) ) 

use mfCarlRepos

SELECT  crn
      , admission
      , admdate
      , admtime
      , disdate
      , admsource
      , admtype
FROM    dbo.admissions as table_name1
WHERE   admdate between '2010-04-01' AND '2010-08-31' 
        and exists ( Select *
                     FROM   dbo.admissions as ALZDBA
                     WHERE  ALZDBA.crn = table_name1.crn 
                            and ALZDBA.admdate > table_name1.admdate
                            and ALZDBA.admdate <= dateadd(dd, 14, table_name1.admdate) 
                            /* tell your system what you know - this may help filtering your initial indexes and reduce the working set */
                            and ALZDBA.admdate between '2010-04-01' AND '2010-08-31'
                            )

 

     Jul 13  

Sometimes this is me

declare @t table (CRN int, admdate smalldatetime)
insert into @t
select 1234,'05/19/2010' union all
select 1234 ,'08/15/2010' union all
select 1234 ,'08/20/2010' union all
select 3456 ,'07/01/2010' union all
select 3456 ,'08/11/2010' union all
select 3456 ,'08/14/2010' 

;with cte as
(select CRN, ADMDate, 
	ROW_NUMBER() over (PARTITION by CRN order by CRN, ADMDate) RowNum
  from @t)
  
select a.CRN, a.admdate 
  from cte a 
	left outer join cte b
		on a.CRN = b.CRN
	   and a.RowNum = b.RowNum - 1
 where DATEDIFF(d, a.admdate, b.admdate) <= 14

     Jul 13  

Sometimes this is me

use mfCarlRepos

SELECT  crn
      , admission
      , admdate
      , admtime
      , disdate
      , admsource
      , admtype
FROM    dbo.admissions as table_name1
WHERE   admdate between '2010-04-01' AND '2010-08-31' 
        and exists ( Select *
                     FROM   dbo.admissions as ALZDBA
                     WHERE  ALZDBA.crn = table_name1.crn 
                            and ALZDBA.admdate > table_name1.admdate
                            and ALZDBA.admdate <= dateadd(dd, 14, table_name1.DISdate) 
                            /* tell your system what you know - this may help filtering your initial indexes and reduce the working set */
                            and ALZDBA.admdate between '2010-04-01' AND '2010-08-31'

     Jul 13  

Sometimes this is me