SQL语句自动补全考勤记录

sqlserver:
declare @insertStartTime varchar(50) 
declare @insertTimeRange int
declare @searchStartDate varchar(50)
declare @searchEndDate varchar(50)
declare @searchStartTime varchar(50)
declare @searchEndTime varchar(50)
declare @searchName int
set @searchStartDate='2016-01-01'
set @searchEndDate  ='2016-02-01'
set @searchStartTime='17:30:00'
set @searchEndTime  ='17:59:59'
set @insertStartTime = '2016-01-01 17:30:00'
set @insertTimeRange=10
set @searchName= 35
--set IDENTITY_INSERT  kt_jl on

INSERT INTO kt_jl(sj,user_serial, xh, fx, lrxh) SELECT dateadd(second,abs(checksum(newid()))%60,dateadd(minute,abs(checksum(newid()))%30, dateadd(day,dd-day(@insertStartTime),@insertStartTime))),@searchName, 0, 0, null FROM (
SELECT
    od.dd,
sum(od.orderCount) orderCount
FROM
    (
        SELECT
            day(sj) dd,
            count(*) orderCount
        FROM
            kt_jl
where sj>=@searchStartDate and sj<@searchEndDate and convert(char(8),sj,108)>=@searchStartTime and convert(char(8),sj,108)<=@searchEndTime and user_serial=@searchName