SELECT Auth_ID FROM #Request.prefix_db_agency#.ScheduleItems where ScheduleItems_ID='#Scheduleitem_id#' update #Request.prefix_db_agency#.ScheduleItems SET Auth_ID='#Authid#' where ScheduleItems_ID='#Scheduleitem_id#' select Auth_Details_ID from #Request.prefix_db_agency#.authorizations_details where Auth_ID='#Authid#' and ScheduleItems_ID is null order by Auth_Details_ID asc limit 1 update #Request.prefix_db_agency#.authorizations_details SET ScheduleItems_ID= #Scheduleitem_id# where Auth_Details_ID=#GetAuth_Details_ID.Auth_Details_ID# and Auth_ID='#Authid#' and ScheduleItems_ID is null