Loop, BULK Insert data (date value)

create proc Setup_list_add@creatime  datetime--creation time, @objjc varchar (20)--Schedule item, @Doctor varchar (20)--admissions physician, @ Begindate datetime--Schedule started, @endtDate datetime--scheduled end, @objuser Varchar (20)--shift asbeginbegin transaction T1declare @n Datetimeset @[email protected]while @n<[email protected]begin insert INTO Scheduling_setup (Creatime,objjc,Doctor, Begintime,endtime,objuser)  Select @creatime, @objjc, @Doctor, CONVERT (char (+), @n+begintime,120), endtime,@ Objuser from Times_setup where [email protected]set @n=dateadd (dd,1,@n) endIF @ @ERROR <> 0 GOTO finalroll Select ' Add to msg,1 CodeCOMMIT TRAN t1returnfinalroll:    Select ' Add failed '  msg,2 coderollback TRAN T1endgo

Loop, BULK Insert data (date value)