FROM [livedb].[dbo].[AbstractData]
where AdmitDateTime>'2018-11-01' AND PtStatus='IN'
select * from #IPats
if OBJECT_ID(N'tempdb..#LOSDATE') is not null
Begin
drop table #LOSDATE
End
create table #LOSDATE(
VID varchar (255),
LOSDATE datetime,
LOS int);
declare @CYB as datetime;
select @CYB = '2018-10-30'
begin
while @CYB<getdate()
Declare @n INT;
declare @i int;
select @n = count(*) from #IPats
select @i=0
begin
while @i<@n
insert into #LOSDATE(VID,LOSDATE,LOS)
select PAT.AccountNumber,
@CYB as LOSDATE,
case when PAT.AdmitDate>@CYB then 0 else
case when PAT.Discharge<=@CYB then 0 else
case when PAT.Discharge is null then datediff(d,PAT.AdmitDate,getdate()) else
Case when PAT.Discharge >= @CYB then datediff(d,PAT.AdmitDate,@CYB) else datediff(d,PAT.AdmitDate,PAT.Discharge) end end end end as LOS
from #IPats PAT
set @i=@i+1;
Thank you
Glen