SQL

select * from importheader

delete from importheader where sizes is null and model is null

select * from importdetail

select * from calendar

select * from rma_detail

select * from rma_header
--select * from importheader
--select * from calendar

select sizes,model,customer,Qty,Convert(varchar(10),Convert(datetime,endday),111) endday,null as rmano,'RMA' type,site
from importheader

declare @sizes varchar(50)
declare @model varchar(50)
declare @customer varchar(50)
declare @qty int
declare @endday varchar(10)
declare @site varchar(20)

declare cursor1 cursor for
select sizes,model,customer,Qty,Convert(varchar(10),Convert(datetime,endday),111) endday,site from importheader

open cursor1
fetch next from cursor1 into @sizes,@model,@customer,@qty,@endday,@site

while @@fetch_status=0
 begin
  insert into rma_header(sizes,model,customer,qty,endday,rmano,type,site,sub_site)
   values(@sizes,@model,@customer,@qty,@endday,null,'RMA',@site,'2')
  fetch next from cursor1 into @sizes,@model,@customer,@qty,@endday,@site
 end

close cursor1
deallocate cursor1

 

select * from importdetail
select * from calendar
select * from rma_detail

declare @customer varchar(50)
declare @sizes varchar(50)
declare @model varchar(50)
declare @endday varchar(10)
declare @defect varchar(50)
declare @defectdaily varchar(50)
declare @modyear int
declare @modquarter int
declare @modmonth int
declare @modweek int
declare @monthorder int
declare @weekorder int
declare @site varchar(20)
declare @barcode varchar(50)

declare cursor1 cursor for
select a.customer,a.sizes,a.model,a.endday,a.defect,a.defectdaily,b.modyear,b.modquarter,b.modmonth
 ,b.modweek,b.monthorder,b.weekorder,a.site,a.barcode
from importdetail a left join calendar b on Convert(varchar(10),Convert(datetime,a.endday),111)=convert(varchar(10),Convert(datetime,b.theday),111)

open cursor1
fetch next from cursor1 into @customer,@sizes,@model,@endday,@defect,@defectdaily,@modyear,@modquarter
 ,@modmonth,@modweek,@monthorder,@weekorder,@site,@barcode

while @@fetch_status=0
 begin
  insert into rma_detail(customer,sizes,model,endday,defect,defectdaily,modyear,modquarter,modmonth,modweek,monthorder,
   weekorder,type,site,barcode,sub_site)
  values( @customer,@sizes,@model,@endday,@defect,@defectdaily,@modyear,@modquarter
   ,@modmonth,@modweek,@monthorder,@weekorder,'RMA',@site,@barcode,'2')
  fetch next from cursor1 into @customer,@sizes,@model,@endday,@defect,@defectdaily,@modyear,@modquarter
   ,@modmonth,@modweek,@monthorder,@weekorder,@site,@barcode
 end
close cursor1
deallocate cursor1