DECLARE @cPRPCOD VARCHAR(20), @cROMTYP VARCHAR(3),@cFRMDAT INT,@cTOODAT INT,@cFTRSGL NUMERIC(20,5)      
      
  DECLARE CUR CURSOR FOR      
   SELECT TTB.PRPCOD,TTB.ROMTYP,TTB.FRMDAT,TTB.TOODAT,TTB.TBLTYP,TTB.FTRSGL       
   FROM HSTTBTBL TTB       
   WHERE TTB.TBLTYP = 'R' AND ISNULL(TTB.PACCOD,0) = 0    
   ORDER BY TTB.PRPCOD,TTB.ROMTYP,TTB.TBLTYP,TTB.FRMDAT       
  OPEN CUR       
   FETCH NEXT FROM CUR INTO @cPRPCOD,@cROMTYP,@cFRMDAT,@cTOODAT,@TBLTYP,@cFTRSGL       
   WHILE @@FETCH_STATUS = 0      
   BEGIN      
    update avl set avl.FTRSGL = @cFTRSGL      
    FROM #ALLAVLROOMTYPE AVL      
    where AVL.RUNDAT between @cFRMDAT and @cTOODAT      
    AND AVL.PRPCOD = @cPRPCOD AND AVL.ROMTYP = @cROMTYP      
      
    FETCH NEXT FROM CUR INTO @cPRPCOD,@cROMTYP,@cFRMDAT,@cTOODAT,@TBLTYP,@cFTRSGL       
   END      
  CLOSE CUR      
  DEALLOCATE CUR   

update avl
set avl.FTRSGL = dt.FTRSGL
FROM #ALLAVLROOMTYPE AVL
join
(SELECT TTB.PRPCOD,TTB.ROMTYP,TTB.FRMDAT,TTB.TOODAT,TTB.TBLTYP,TTB.FTRSGL
 FROM HSTTBTBL TTB
 WHERE TTB.TBLTYP = 'R' AND ISNULL(TTB.PACCOD,0) = 0)dt
on AVL.RUNDAT between dt.FRMDAT and dt.TOODAT AND 
   AVL.PRPCOD = dt.PRPCOD AND 
   AVL.ROMTYP = dt.ROMTYP

quote:

---

Originally posted by haroon2k9

Thank you very much for both of you..

Thanks once agian to Webfred and Visakh

---