declare @hospital table(PatientID int,AdmissionDate datetime,DischargeDate datetime,Cost numeric(10,2))
insert into @hospital select
709,'2011-07-27 00:00:00.000','2011-07-31 00:00:00.000',450.00 union all select
709,'2011-08-01 00:00:00.000','2011-08-23 00:00:00.000',2070.00 union all select
709,'2011-08-31 00:00:00.000','2011-08-31 00:00:00.000',90.00 union all select
709,'2011-09-01 00:00:00.000','2011-09-14 00:00:00.000',1260.00 union all select
709,'2011-12-01 00:00:00.000','2011-12-31 00:00:00.000',2790.00 union all select
1624,'2011-06-07 00:00:00.000','2011-06-28 00:00:00.000',1980.00 union all select
1624,'2011-06-29 00:00:00.000','2011-07-31 00:00:00.000',2970.00 union all select
1624,'2011-08-01 00:00:00.000','2011-08-02 00:00:00.000',180.00 union all select
1000,'2013-03-14 18:10:25.687','2013-03-15 12:10:25.687',1000.00 union all select
1001,'2013-03-14 18:10:40.280','2013-03-15 12:10:40.280',2000.00;
select * from @hospital where AdmissionDate > DATEADD(DAY, DATEDIFF(DAY, 0, GETDATE()) - 1 , 0) + 0.75