Post reply

Fill in missing hours for each VisitID during the day

  • November 14, 2024 at 6:11 pm

    #4481843 

    create table #T
    (
    VisitID varchar(30),
    ER_Date date,
    HR int
    )

    insert into #T(VisitID, ER_Date, HR) values('F3-B20241031192313800','11/1/2024',0)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241031155610449','11/1/2024',0)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241031181839474','11/1/2024',0)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241031183744823','11/1/2024',0)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241031215711573','11/1/2024',0)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241031164745365','11/1/2024',0)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241031214614352','11/1/2024',0)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241031173232450','11/1/2024',0)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101003609653','11/1/2024',0)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241031235836377','11/1/2024',0)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241031225044156','11/1/2024',0)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241031150414832','11/1/2024',0)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241031191749157','11/1/2024',0)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241031201144561','11/1/2024',0)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241031193204161','11/1/2024',0)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241031152805265','11/1/2024',0)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241031163057209','11/1/2024',0)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241031122259833','11/1/2024',0)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241031233556094','11/1/2024',0)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101010035937','11/1/2024',1)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241031235836377','11/1/2024',1)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101003609653','11/1/2024',1)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101015610159','11/1/2024',1)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241031203956980','11/1/2024',1)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241031150414832','11/1/2024',1)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241031183744823','11/1/2024',1)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241031204523425','11/1/2024',1)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241031193204161','11/1/2024',1)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241031152805265','11/1/2024',1)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101013902463','11/1/2024',1)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101010104297','11/1/2024',1)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241031230155712','11/1/2024',1)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241031170646815','11/1/2024',1)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241031225041853','11/1/2024',1)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241031164745365','11/1/2024',1)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101012405690','11/1/2024',1)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101015624024','11/1/2024',1)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241031191749157','11/1/2024',1)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241031230155712','11/1/2024',2)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241031235836377','11/1/2024',2)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241031225044156','11/1/2024',2)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101015610159','11/1/2024',2)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241031104447087','11/1/2024',2)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101003609653','11/1/2024',2)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20240924155251870','11/1/2024',2)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241031133446961','11/1/2024',2)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101012405690','11/1/2024',2)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101015624024','11/1/2024',2)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101010104297','11/1/2024',2)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241031193756337','11/1/2024',2)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241031152805265','11/1/2024',2)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101023404626','11/1/2024',2)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241031163057209','11/1/2024',2)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101023734854','11/1/2024',2)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241031173232450','11/1/2024',2)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241031214614352','11/1/2024',2)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101013902463','11/1/2024',2)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241031191749157','11/1/2024',2)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241031163057209','11/1/2024',3)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101033804839','11/1/2024',3)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241031233556094','11/1/2024',3)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101035635115','11/1/2024',3)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101015624024','11/1/2024',3)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241031181020527','11/1/2024',3)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101023404626','11/1/2024',3)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241031114725360','11/1/2024',3)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101023734854','11/1/2024',3)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101030006274','11/1/2024',3)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241031173232450','11/1/2024',3)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241031214614352','11/1/2024',3)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241030143439825','11/1/2024',3)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101013902463','11/1/2024',3)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241031163057209','11/1/2024',4)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101003609653','11/1/2024',4)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101010104297','11/1/2024',4)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101012405690','11/1/2024',4)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101023734854','11/1/2024',4)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101013902463','11/1/2024',4)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241031181020527','11/1/2024',4)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101035635115','11/1/2024',4)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241031183744823','11/1/2024',4)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101043052267','11/1/2024',4)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241031235836377','11/1/2024',4)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241031170531730','11/1/2024',4)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101010035937','11/1/2024',4)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101015610159','11/1/2024',4)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101023734854','11/1/2024',5)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101053442273','11/1/2024',5)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101015624024','11/1/2024',5)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101012405690','11/1/2024',5)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101010104297','11/1/2024',5)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241031163057209','11/1/2024',5)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101052705407','11/1/2024',5)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101013902463','11/1/2024',5)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241031183744823','11/1/2024',5)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101054629659','11/1/2024',5)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101033804839','11/1/2024',5)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101055242793','11/1/2024',5)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241031235836377','11/1/2024',5)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101043052267','11/1/2024',5)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241031170531730','11/1/2024',6)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241031183744823','11/1/2024',6)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101013902463','11/1/2024',6)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101053442273','11/1/2024',6)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241031173232450','11/1/2024',6)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101015624024','11/1/2024',6)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101062932191','11/1/2024',6)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101064400906','11/1/2024',6)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241028143506410','11/1/2024',6)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101052705407','11/1/2024',6)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241029184656024','11/1/2024',6)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241031233556094','11/1/2024',6)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101023734854','11/1/2024',6)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241031235836377','11/1/2024',6)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101012405690','11/1/2024',6)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101054629659','11/1/2024',6)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101035635115','11/1/2024',6)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101033804839','11/1/2024',6)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241031225044156','11/1/2024',6)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101055242793','11/1/2024',6)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101070533592','11/1/2024',7)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241031235836377','11/1/2024',7)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101010035937','11/1/2024',7)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101071807651','11/1/2024',7)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101013902463','11/1/2024',7)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101054629659','11/1/2024',7)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241030214858505','11/1/2024',7)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101071453563','11/1/2024',7)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241030190217397','11/1/2024',7)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241031170531730','11/1/2024',7)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241025150004315','11/1/2024',7)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241031181839474','11/1/2024',7)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241030143439825','11/1/2024',7)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101043052267','11/1/2024',7)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241031163057209','11/1/2024',7)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101055242793','11/1/2024',7)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241031181020527','11/1/2024',7)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101062932191','11/1/2024',7)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101052705407','11/1/2024',7)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241030101221331','11/1/2024',7)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101035635115','11/1/2024',7)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101030006274','11/1/2024',7)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241029184656024','11/1/2024',7)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101023734854','11/1/2024',7)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241030113500969','11/1/2024',7)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101033804839','11/1/2024',7)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241031233556094','11/1/2024',7)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101015624024','11/1/2024',7)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101064400906','11/1/2024',7)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101080518949','11/1/2024',8)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101062932191','11/1/2024',8)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241031111144569','11/1/2024',8)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241031150414832','11/1/2024',8)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241028225436848','11/1/2024',8)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241028125808397','11/1/2024',8)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101071807651','11/1/2024',8)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101043052267','11/1/2024',8)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101084027168','11/1/2024',8)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241031235836377','11/1/2024',8)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101054629659','11/1/2024',8)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101083201825','11/1/2024',8)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241030190217397','11/1/2024',8)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101083404199','11/1/2024',8)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241025080209742','11/1/2024',8)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101055242793','11/1/2024',8)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101052705407','11/1/2024',8)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101083225656','11/1/2024',8)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101080313558','11/1/2024',8)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241030143439825','11/1/2024',8)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101033804839','11/1/2024',8)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101081121259','11/1/2024',8)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101070533592','11/1/2024',8)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101064400906','11/1/2024',8)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241031120628275','11/1/2024',8)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101035635115','11/1/2024',8)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241031233556094','11/1/2024',8)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101023734854','11/1/2024',8)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241025150004315','11/1/2024',8)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101071453563','11/1/2024',8)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101095733907','11/1/2024',9)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241031233556094','11/1/2024',9)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101090312127','11/1/2024',9)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101033804839','11/1/2024',9)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101092615289','11/1/2024',9)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241024075218679','11/1/2024',9)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241028092216546','11/1/2024',9)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101071807651','11/1/2024',9)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101090825252','11/1/2024',9)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101092030633','11/1/2024',9)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101091310797','11/1/2024',9)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101094223828','11/1/2024',9)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241024145918433','11/1/2024',9)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101090226823','11/1/2024',9)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101083225656','11/1/2024',9)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101083201825','11/1/2024',9)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101094452896','11/1/2024',9)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101094520191','11/1/2024',9)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101043052267','11/1/2024',9)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101091202835','11/1/2024',9)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101092741585','11/1/2024',9)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101080313558','11/1/2024',9)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101091453566','11/1/2024',9)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101083404199','11/1/2024',9)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101084027168','11/1/2024',9)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101093943701','11/1/2024',9)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101092950703','11/1/2024',9)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101093140523','11/1/2024',9)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101100128206','11/1/2024',10)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101092615289','11/1/2024',10)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101100656972','11/1/2024',10)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101104137201','11/1/2024',10)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101094452896','11/1/2024',10)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101105148575','11/1/2024',10)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101080518949','11/1/2024',10)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101093140523','11/1/2024',10)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101104806362','11/1/2024',10)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101101710557','11/1/2024',10)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101092950703','11/1/2024',10)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101090312127','11/1/2024',10)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101083201825','11/1/2024',10)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101094223828','11/1/2024',10)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101105631979','11/1/2024',10)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101095733907','11/1/2024',10)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101043052267','11/1/2024',10)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101052705407','11/1/2024',10)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101104626421','11/1/2024',10)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101104223019','11/1/2024',10)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241030092508912','11/1/2024',10)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101090825252','11/1/2024',10)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101094520191','11/1/2024',10)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101083404199','11/1/2024',10)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241030214858505','11/1/2024',10)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101091202835','11/1/2024',10)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101102944073','11/1/2024',10)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101071453563','11/1/2024',10)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101091453566','11/1/2024',10)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101080313558','11/1/2024',10)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101091310797','11/1/2024',10)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241028132647997','11/1/2024',10)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101102858117','11/1/2024',10)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101083225656','11/1/2024',10)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101090312127','11/1/2024',11)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101110931549','11/1/2024',11)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101110034207','11/1/2024',11)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101102944073','11/1/2024',11)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101083225656','11/1/2024',11)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101114404670','11/1/2024',11)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101100656972','11/1/2024',11)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101080313558','11/1/2024',11)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101083201825','11/1/2024',11)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101110604990','11/1/2024',11)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101101710557','11/1/2024',11)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101114902670','11/1/2024',11)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101114002674','11/1/2024',11)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101105631979','11/1/2024',11)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101110504433','11/1/2024',11)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101104223019','11/1/2024',11)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101104626421','11/1/2024',11)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101111437364','11/1/2024',11)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101094223828','11/1/2024',11)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101111052574','11/1/2024',11)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101091453566','11/1/2024',11)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101094452896','11/1/2024',11)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101112924172','11/1/2024',11)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101094520191','11/1/2024',11)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101093140523','11/1/2024',11)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101102858117','11/1/2024',11)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101081121259','11/1/2024',11)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101104806362','11/1/2024',11)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101114542633','11/1/2024',11)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241031181020527','11/1/2024',11)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101105148575','11/1/2024',11)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101115528753','11/1/2024',11)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241030112832169','11/1/2024',11)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101083404199','11/1/2024',11)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241030163329532','11/1/2024',12)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241029073447420','11/1/2024',12)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101125444318','11/1/2024',12)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101110504433','11/1/2024',12)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101083225656','11/1/2024',12)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101092030633','11/1/2024',12)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101125855060','11/1/2024',12)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241025172550189','11/1/2024',12)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101102944073','11/1/2024',12)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101084027168','11/1/2024',12)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101102858117','11/1/2024',12)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241031095735499','11/1/2024',12)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241028205252077','11/1/2024',12)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101115528753','11/1/2024',12)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101104626421','11/1/2024',12)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101111437364','11/1/2024',12)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241029130400600','11/1/2024',12)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101080518949','11/1/2024',12)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101091453566','11/1/2024',12)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101080313558','11/1/2024',12)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241026084108524','11/1/2024',12)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101112924172','11/1/2024',12)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101114002674','11/1/2024',12)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241024111635387','11/1/2024',12)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101114404670','11/1/2024',12)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101124436632','11/1/2024',12)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101104137201','11/1/2024',12)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101094452896','11/1/2024',12)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101111052574','11/1/2024',12)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241028125808397','11/1/2024',12)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101110034207','11/1/2024',12)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241028132647997','11/1/2024',12)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101114902670','11/1/2024',12)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101081121259','11/1/2024',12)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101125651261','11/1/2024',12)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101121414324','11/1/2024',12)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241025133907805','11/1/2024',12)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101105148575','11/1/2024',12)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101124948864','11/1/2024',12)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101101710557','11/1/2024',12)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101104223019','11/1/2024',12)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101121833172','11/1/2024',12)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101110931549','11/1/2024',12)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101120753263','11/1/2024',12)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101095733907','11/1/2024',12)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101125251398','11/1/2024',12)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101114542633','11/1/2024',12)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241026102123863','11/1/2024',12)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101124613225','11/1/2024',12)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101030006274','11/1/2024',12)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101122624877','11/1/2024',12)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101092950703','11/1/2024',12)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241031071801769','11/1/2024',12)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241021113847021','11/1/2024',12)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241031084953710','11/1/2024',12)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101120118293','11/1/2024',12)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241028092216546','11/1/2024',12)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101120753263','11/1/2024',13)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101094223828','11/1/2024',13)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101080313558','11/1/2024',13)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101111052574','11/1/2024',13)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241030111037675','11/1/2024',13)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101090226823','11/1/2024',13)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101124436632','11/1/2024',13)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101083225656','11/1/2024',13)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101102858117','11/1/2024',13)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101084027168','11/1/2024',13)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101125651261','11/1/2024',13)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241029130400600','11/1/2024',13)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241030123624642','11/1/2024',13)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101131900585','11/1/2024',13)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101120118293','11/1/2024',13)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101125855060','11/1/2024',13)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101110504433','11/1/2024',13)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241026010100347','11/1/2024',13)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241031084953710','11/1/2024',13)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241024123448371','11/1/2024',13)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101102944073','11/1/2024',13)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101114542633','11/1/2024',13)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241031124318039','11/1/2024',13)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241025133907805','11/1/2024',13)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101114404670','11/1/2024',13)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241025024637114','11/1/2024',13)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101132743279','11/1/2024',13)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101080518949','11/1/2024',13)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241031164745365','11/1/2024',13)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101030006274','11/1/2024',13)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101124613225','11/1/2024',13)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101121833172','11/1/2024',13)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101122624877','11/1/2024',13)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101104626421','11/1/2024',13)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101131447465','11/1/2024',13)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241026120524861','11/1/2024',13)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101111437364','11/1/2024',13)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241028125808397','11/1/2024',13)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101130618244','11/1/2024',13)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101114902670','11/1/2024',13)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241028111312358','11/1/2024',13)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241024111635387','11/1/2024',13)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101125251398','11/1/2024',13)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101133240293','11/1/2024',13)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241026182830889','11/1/2024',13)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101104137201','11/1/2024',13)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101130159125','11/1/2024',13)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101121414324','11/1/2024',13)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101094452896','11/1/2024',13)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241026102123863','11/1/2024',13)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101105148575','11/1/2024',13)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101124948864','11/1/2024',13)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101100128206','11/1/2024',13)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241026084108524','11/1/2024',13)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101092615289','11/1/2024',13)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101125444318','11/1/2024',13)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101141255065','11/1/2024',14)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241025150004315','11/1/2024',14)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101132743279','11/1/2024',14)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241025024637114','11/1/2024',14)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101142058401','11/1/2024',14)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101133240293','11/1/2024',14)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241028050853940','11/1/2024',14)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241031183744823','11/1/2024',14)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101145538966','11/1/2024',14)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101120118293','11/1/2024',14)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101143955623','11/1/2024',14)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101104626421','11/1/2024',14)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101084027168','11/1/2024',14)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101144343846','11/1/2024',14)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101093140523','11/1/2024',14)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101125251398','11/1/2024',14)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101145459678','11/1/2024',14)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101100128206','11/1/2024',14)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101131447465','11/1/2024',14)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101110504433','11/1/2024',14)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101124436632','11/1/2024',14)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241030111037675','11/1/2024',14)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241031084953710','11/1/2024',14)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241030163329532','11/1/2024',14)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101083201825','11/1/2024',14)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241026193952800','11/1/2024',14)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241026120524861','11/1/2024',14)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241031181020527','11/1/2024',14)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101115528753','11/1/2024',14)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101130618244','11/1/2024',14)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101125855060','11/1/2024',14)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101131900585','11/1/2024',14)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101094452896','11/1/2024',14)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101095733907','11/1/2024',14)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101090226823','11/1/2024',14)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241028092216546','11/1/2024',14)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101120753263','11/1/2024',14)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101125444318','11/1/2024',14)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101080313558','11/1/2024',14)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101122624877','11/1/2024',14)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101124613225','11/1/2024',14)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101111052574','11/1/2024',14)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101141701451','11/1/2024',14)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241027215144242','11/1/2024',14)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101100656972','11/1/2024',14)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101141834603','11/1/2024',14)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101130159125','11/1/2024',14)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101121414324','11/1/2024',14)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101092615289','11/1/2024',14)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101110034207','11/1/2024',14)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241026084108524','11/1/2024',14)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101080518949','11/1/2024',14)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101141356667','11/1/2024',14)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101033804839','11/1/2024',14)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101092030633','11/1/2024',14)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241026182830889','11/1/2024',14)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101124948864','11/1/2024',14)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101145654669','11/1/2024',14)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101105631979','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20240930005657783','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101120118293','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101141255065','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101131447465','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101151827856','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101115528753','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101100128206','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101143955623','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241030214858505','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101133240293','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101114542633','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101124613225','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101142058401','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101121833172','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241031183744823','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241031163057209','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101151134236','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101150551412','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101104223019','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101145538966','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101124948864','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101154314802','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241018152547287','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101125651261','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101121414324','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101122624877','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101111437364','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241031181839474','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101130618244','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101124436632','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101141701451','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241028225436848','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101154030005','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101100656972','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101152437245','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101155437261','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101120753263','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101151954258','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101114002674','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101144343846','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101110034207','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101033804839','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241031181020527','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101145654669','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101145459678','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101125855060','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101030006274','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101080518949','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101154633168','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101130159125','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101090226823','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101071807651','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101092030633','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101131900585','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101152037924','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101153856990','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101125444318','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101110504433','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241029124747187','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101141834603','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241029184656024','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101141356667','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101151319672','11/1/2024',15)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101131447465','11/1/2024',16)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101142058401','11/1/2024',16)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101121833172','11/1/2024',16)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101150551412','11/1/2024',16)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101162427357','11/1/2024',16)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101120753263','11/1/2024',16)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101125251398','11/1/2024',16)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101151134236','11/1/2024',16)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241025024637114','11/1/2024',16)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241031164610578','11/1/2024',16)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101145538966','11/1/2024',16)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101151954258','11/1/2024',16)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101132743279','11/1/2024',16)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241026123507297','11/1/2024',16)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101162051394','11/1/2024',16)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101111437364','11/1/2024',16)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101151827856','11/1/2024',16)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101144343846','11/1/2024',16)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101153856990','11/1/2024',16)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101145654669','11/1/2024',16)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101080518949','11/1/2024',16)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241030142216902','11/1/2024',16)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101143955623','11/1/2024',16)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101165959212','11/1/2024',16)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101141255065','11/1/2024',16)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101165001803','11/1/2024',16)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101091453566','11/1/2024',16)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101124613225','11/1/2024',16)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101122624877','11/1/2024',16)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101145459678','11/1/2024',16)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101141701451','11/1/2024',16)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101161722759','11/1/2024',16)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101114404670','11/1/2024',16)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101131900585','11/1/2024',16)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101124436632','11/1/2024',16)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241027215144242','11/1/2024',16)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101154633168','11/1/2024',16)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101141356667','11/1/2024',16)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101151319672','11/1/2024',16)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101165351302','11/1/2024',16)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101164349468','11/1/2024',16)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101155437261','11/1/2024',16)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101152437245','11/1/2024',16)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101100656972','11/1/2024',16)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241028225436848','11/1/2024',16)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101161252134','11/1/2024',16)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101110034207','11/1/2024',16)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101141834603','11/1/2024',16)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101154314802','11/1/2024',16)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101154030005','11/1/2024',16)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101164059054','11/1/2024',16)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101170241716','11/1/2024',17)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101125251398','11/1/2024',17)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101141255065','11/1/2024',17)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241026123507297','11/1/2024',17)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101132743279','11/1/2024',17)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101174214299','11/1/2024',17)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241030203551370','11/1/2024',17)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101165959212','11/1/2024',17)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101124613225','11/1/2024',17)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101153856990','11/1/2024',17)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101125444318','11/1/2024',17)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101173621243','11/1/2024',17)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101120753263','11/1/2024',17)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101152437245','11/1/2024',17)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101151954258','11/1/2024',17)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101151134236','11/1/2024',17)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101165351302','11/1/2024',17)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101161252134','11/1/2024',17)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101154314802','11/1/2024',17)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101100128206','11/1/2024',17)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101173723587','11/1/2024',17)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101155437261','11/1/2024',17)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101151319672','11/1/2024',17)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101164349468','11/1/2024',17)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101033804839','11/1/2024',17)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101171940041','11/1/2024',17)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101175747246','11/1/2024',17)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101100656972','11/1/2024',17)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101175737578','11/1/2024',17)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101130159125','11/1/2024',17)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101131900585','11/1/2024',17)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101150551412','11/1/2024',17)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101161722759','11/1/2024',17)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101173325468','11/1/2024',17)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101171418840','11/1/2024',17)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101091453566','11/1/2024',17)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101154030005','11/1/2024',17)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101124436632','11/1/2024',17)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101131447465','11/1/2024',17)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101165001803','11/1/2024',17)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101092030633','11/1/2024',17)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101175544982','11/1/2024',17)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101170942627','11/1/2024',17)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101164059054','11/1/2024',17)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101154633168','11/1/2024',17)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101154314802','11/1/2024',18)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101100656972','11/1/2024',18)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101161252134','11/1/2024',18)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101100128206','11/1/2024',18)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101175737578','11/1/2024',18)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101154633168','11/1/2024',18)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101184629680','11/1/2024',18)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101173723587','11/1/2024',18)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101122624877','11/1/2024',18)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101164349468','11/1/2024',18)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101141356667','11/1/2024',18)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101151319672','11/1/2024',18)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101124613225','11/1/2024',18)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101151954258','11/1/2024',18)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101145654669','11/1/2024',18)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101174214299','11/1/2024',18)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101182045785','11/1/2024',18)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101170241716','11/1/2024',18)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101185339957','11/1/2024',18)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101130618244','11/1/2024',18)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101164059054','11/1/2024',18)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101173621243','11/1/2024',18)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101165351302','11/1/2024',18)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101175747246','11/1/2024',18)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241012105217623','11/1/2024',18)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101132743279','11/1/2024',18)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101181126624','11/1/2024',18)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101182021797','11/1/2024',18)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101180615192','11/1/2024',18)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101141255065','11/1/2024',18)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101165959212','11/1/2024',18)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101175544982','11/1/2024',18)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101181043564','11/1/2024',18)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101183136419','11/1/2024',18)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101165001803','11/1/2024',18)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101185741726','11/1/2024',18)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101173325468','11/1/2024',18)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101171418840','11/1/2024',18)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101080313558','11/1/2024',18)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101184132680','11/1/2024',18)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101170942627','11/1/2024',18)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101171940041','11/1/2024',18)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101195759384','11/1/2024',19)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241029184656024','11/1/2024',19)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101164059054','11/1/2024',19)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101152437245','11/1/2024',19)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101193149566','11/1/2024',19)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101092030633','11/1/2024',19)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101175737578','11/1/2024',19)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101173723587','11/1/2024',19)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101185741726','11/1/2024',19)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101171418840','11/1/2024',19)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101170942627','11/1/2024',19)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241029124747187','11/1/2024',19)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101192812628','11/1/2024',19)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241029070208659','11/1/2024',19)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101191313217','11/1/2024',19)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101181043564','11/1/2024',19)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101183136419','11/1/2024',19)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101173325468','11/1/2024',19)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101175544982','11/1/2024',19)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101180615192','11/1/2024',19)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101192030934','11/1/2024',19)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101182021797','11/1/2024',19)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101185339957','11/1/2024',19)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101171940041','11/1/2024',19)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101194038264','11/1/2024',19)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101151827856','11/1/2024',19)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101162427357','11/1/2024',19)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101184629680','11/1/2024',19)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101151954258','11/1/2024',19)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101174214299','11/1/2024',19)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101165959212','11/1/2024',19)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101023734854','11/1/2024',19)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101181126624','11/1/2024',19)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101190041156','11/1/2024',19)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101170241716','11/1/2024',19)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101173621243','11/1/2024',19)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101125251398','11/1/2024',19)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241030214858505','11/1/2024',19)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101193511386','11/1/2024',19)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101190131236','11/1/2024',19)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241031181839474','11/1/2024',19)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241031181020527','11/1/2024',19)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101173723587','11/1/2024',20)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101141356667','11/1/2024',20)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101170942627','11/1/2024',20)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101185741726','11/1/2024',20)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101080313558','11/1/2024',20)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101171418840','11/1/2024',20)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101181043564','11/1/2024',20)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101165001803','11/1/2024',20)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101171940041','11/1/2024',20)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101191313217','11/1/2024',20)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101145459678','11/1/2024',20)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101194038264','11/1/2024',20)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101205201386','11/1/2024',20)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101165351302','11/1/2024',20)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101114002674','11/1/2024',20)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101192812628','11/1/2024',20)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101193149566','11/1/2024',20)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101164059054','11/1/2024',20)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101130618244','11/1/2024',20)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241031181839474','11/1/2024',20)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101195759384','11/1/2024',20)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101185339957','11/1/2024',20)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101182045785','11/1/2024',20)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101092030633','11/1/2024',20)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101124948864','11/1/2024',20)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101193511386','11/1/2024',20)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101202032496','11/1/2024',20)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101151954258','11/1/2024',20)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101184132680','11/1/2024',20)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101190131236','11/1/2024',20)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101190041156','11/1/2024',20)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101175544982','11/1/2024',20)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101170241716','11/1/2024',20)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101204203370','11/1/2024',20)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101151827856','11/1/2024',20)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101192030934','11/1/2024',20)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101180615192','11/1/2024',20)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101173621243','11/1/2024',20)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101184629680','11/1/2024',20)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101130618244','11/1/2024',21)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101151319672','11/1/2024',21)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101202032496','11/1/2024',21)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101150551412','11/1/2024',21)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101193511386','11/1/2024',21)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101193149566','11/1/2024',21)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101192812628','11/1/2024',21)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101152437245','11/1/2024',21)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101164349468','11/1/2024',21)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101210440692','11/1/2024',21)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101165001803','11/1/2024',21)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101175737578','11/1/2024',21)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101171940041','11/1/2024',21)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101214335053','11/1/2024',21)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101183136419','11/1/2024',21)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101181043564','11/1/2024',21)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101212441345','11/1/2024',21)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101214658928','11/1/2024',21)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101192030934','11/1/2024',21)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101114002674','11/1/2024',21)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101175544982','11/1/2024',21)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101180615192','11/1/2024',21)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101214935135','11/1/2024',21)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101185339957','11/1/2024',21)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101214102278','11/1/2024',21)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101185741726','11/1/2024',21)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101164059054','11/1/2024',21)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101205201386','11/1/2024',21)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101194038264','11/1/2024',21)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101162427357','11/1/2024',21)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101213513972','11/1/2024',21)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101184132680','11/1/2024',21)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101190041156','11/1/2024',21)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101175747246','11/1/2024',21)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101151134236','11/1/2024',21)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101170241716','11/1/2024',21)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101204203370','11/1/2024',21)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101214658928','11/1/2024',22)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101132743279','11/1/2024',22)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101174214299','11/1/2024',22)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101205201386','11/1/2024',22)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101165959212','11/1/2024',22)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101222142214','11/1/2024',22)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101220403634','11/1/2024',22)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101175747246','11/1/2024',22)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241031181839474','11/1/2024',22)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101184132680','11/1/2024',22)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101224939106','11/1/2024',22)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101173621243','11/1/2024',22)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101190131236','11/1/2024',22)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101182021797','11/1/2024',22)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101213513972','11/1/2024',22)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101175544982','11/1/2024',22)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101165001803','11/1/2024',22)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101173723587','11/1/2024',22)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101175737578','11/1/2024',22)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101185741726','11/1/2024',22)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101214335053','11/1/2024',22)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101212441345','11/1/2024',22)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101214102278','11/1/2024',22)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101192030934','11/1/2024',22)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101214935135','11/1/2024',22)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101221329506','11/1/2024',22)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101183136419','11/1/2024',22)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101130618244','11/1/2024',22)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101224122900','11/1/2024',22)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101202032496','11/1/2024',22)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101193511386','11/1/2024',22)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101223349278','11/1/2024',22)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101224124643','11/1/2024',22)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101150551412','11/1/2024',22)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101182045785','11/1/2024',22)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101220632478','11/1/2024',22)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101141356667','11/1/2024',22)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101152437245','11/1/2024',22)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101195759384','11/1/2024',22)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101164349468','11/1/2024',22)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101222810708','11/1/2024',22)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101071807651','11/1/2024',23)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101183136419','11/1/2024',23)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101234459221','11/1/2024',23)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101214658928','11/1/2024',23)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101185741726','11/1/2024',23)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101214935135','11/1/2024',23)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101191313217','11/1/2024',23)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101221329506','11/1/2024',23)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101234617864','11/1/2024',23)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101222142214','11/1/2024',23)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101224124643','11/1/2024',23)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101192812628','11/1/2024',23)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101165959212','11/1/2024',23)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101212441345','11/1/2024',23)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101220403634','11/1/2024',23)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101213513972','11/1/2024',23)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101224939106','11/1/2024',23)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101234215326','11/1/2024',23)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241030214858505','11/1/2024',23)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101194038264','11/1/2024',23)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101231155787','11/1/2024',23)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101190131236','11/1/2024',23)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241031104513604','11/1/2024',23)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101150551412','11/1/2024',23)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241031181020527','11/1/2024',23)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101223349278','11/1/2024',23)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101100656972','11/1/2024',23)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101210440692','11/1/2024',23)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101220632478','11/1/2024',23)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241029184656024','11/1/2024',23)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101164349468','11/1/2024',23)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101141834603','11/1/2024',23)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101184629680','11/1/2024',23)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101232824535','11/1/2024',23)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101182045785','11/1/2024',23)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101204203370','11/1/2024',23)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101222810708','11/1/2024',23)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101224122900','11/1/2024',23)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101164059054','11/1/2024',23)
    insert into #T(VisitID, ER_Date, HR) values('F3-B20241101124948864','11/1/2024',23)
    insert into #T(VisitID, ER_Date, HR) values('F2-B20241101233707254','11/1/2024',23)

    Each VisitID represents a visit to the ER. The HR represents the hour of the day that the patient was in the ER. Some hours are missing, meaning that there weren't any nurse entries during that hour. I need to have those hours "filled in". Then, I can add the VisitIDs and HR to a table and count the number of Visits per hour. The goal for the report is to be able to get the census by hour by day for the ER.

  • November 14, 2024 at 6:43 pm

    #4481851

    Silly questions on my part because the likely answer is "Yes" to both of my questions but, I've got to make sure...

    In your given example, is it possible that any given Visit_ID could have a first date prior to the date you want to count hours for or have a last date after the date you want to count hours for?

    EDIT... and, please... do your self a favor... do NOT add any rows to the original table because you're changing the content of an auditable table.  We can do this without adding to the data in the original table.

     

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • November 14, 2024 at 8:06 pm

    #4481878

    First, the VALUES clause can take more than one set of values, so you can take advantage of that to make your script MUCH more concise.

    insert into #T(VisitID, ER_Date, HR) 
    values ('F3-B20241031192313800','11/1/2024',0)
         , ('F2-B20241031155610449','11/1/2024',0)
         , ('F3-B20241031181839474','11/1/2024',0)
         , ('F2-B20241031183744823','11/1/2024',0)
         , ('F2-B20241031215711573','11/1/2024',0)
         , ('F3-B20241031164745365','11/1/2024',0)
         , ('F2-B20241031214614352','11/1/2024',0)
         , ('F3-B20241031173232450','11/1/2024',0)
         , ('F3-B20241101003609653','11/1/2024',0)
         , ('F2-B20241031235836377','11/1/2024',0)
         , ('F3-B20241031225044156','11/1/2024',0)
         , ('F2-B20241031150414832','11/1/2024',0)

    Second, you did not provide expected results so that people could verify their solutions.

    Third, the purpose of posting sample data is to provide enough data to illustrate your  issue without overwhelming anybody who would want to work on it.  The more data you provide, the more complex it is to validate against your (missing) expected results.  Your "sample" has 848 rows with 256 unique visits.  There is nothing that indicates that your issue is that complex.

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply