hi,
i have 3 tables data,sort,fullsort
the columns for data table(lot_no,type,shape,size,place,weight,dt)
sort(lot_no,name,type,shape,size,place,weight,issue_dt)
fullsort(lot_no,name,type,shape,size,place,weight,issue_dt,return_dt)
i have created the following stored procedure