set nocount on
declare @FirstDate varchar(20)
declare @LastDate varchar(20)
DECLARE curNonProd3Ratio Cursor
FOR
select Manufacture,Managementindustry from #Temp
OPEN curNonProd3Ratio
FETCH Next From curNonProd3Ratio into @FirstDate, @LastDate
WHILE @@FETCH_STATUS =0
Begin
select @FirstDate, @LastDate
FETCH Next From curNonProd3Ratio into @FirstDate, @LastDate
End
CLOSE curNonProd3Ratio
DEALLOCATE curNonProd3Ratio