Doubt On sql Cursors in sql.........When i excecuting this sp......Command(s) completed successfully...I am new to CursorsIf any one knows problem in this sp can u plz suggest me
alter procedure [dbo].[sp_update_camasales_using_cursors]
AS
Begin
DECLARE @CSSPCN varchar(17)
DECLARE @CSSSales_Book1 varchar(5)
DECLARE @CSSSales_Page1 varchar(50)
DECLARE @CSSSales_Date1 varchar(9)
DECLARE @CSSSalesInstrument_Type1 varchar(6)
DECLARE @CSSSalesValidity_Code1 char(2)
DECLARE @CSSSalesType_Code1 char(1)
DECLARE @CSSSales_Price1 varchar(10)
DECLARE @CSSSales_Book2 varchar(5)
DECLARE @CSSSales_Page2 varchar(50)
DECLARE @CSSSales_Date2 varchar(9)
DECLARE @CSSSalesInstrument_Type2 varchar(6)
DECLARE @CSSSalesValidity_Code2 char(2)
DECLARE @CSSSalesType_Code2 char(1)
DECLARE @CSSSales_Price2 varchar(10)
DECLARE @CSSSales_Book3 varchar(5)
DECLARE @CSSSales_Page3 varchar(50)
DECLARE @CSSSales_Date3 varchar(9)
DECLARE @CSSSalesInstrument_Type3 varchar(6)
DECLARE @CSSSalesValidity_Code3 char(2)
DECLARE @CSSSalesType_Code3 char(1)
DECLARE @CSSSales_Price3 varchar(10)
DECLARE @CSSSales_Book4 varchar(5)
DECLARE @CSSSales_Page4 varchar(50)
DECLARE @CSSSales_Date4 varchar(9)
DECLARE @CSSSalesInstrument_Type4 varchar(6)
DECLARE @CSSSalesValidity_Code4 char(2)
DECLARE @CSSSalesType_Code4 char(1)
DECLARE @CSSSales_Price4 varchar(10)
DECLARE @CSSSales_Book5 varchar(5)
DECLARE @CSSSales_Page5 varchar(50)
DECLARE @CSSSales_Date5 varchar(9)
DECLARE @CSSSalesInstrument_Type5 varchar(6)
DECLARE @CSSSalesValidity_Code5 char(2)
DECLARE @CSSSalesType_Code5 char(1)
DECLARE @CSSSales_Price5 varchar(10)
DECLARE @CSPCN varchar(17)
DECLARE @CSSales_Book1 varchar(5)
DECLARE @CSSales_Page1 varchar(50)
DECLARE @CSSales_Date1 varchar(9)
DECLARE @CSSalesInstrument_Type1 varchar(6)
DECLARE @CSSalesValidity_Code1 char(2)
DECLARE @CSSalesType_Code1 char(1)
DECLARE @CSSales_Price1 varchar(10)
DECLARE @CSSales_Book2 varchar(5)
DECLARE @CSSales_Page2 varchar(50)
DECLARE @CSSales_Date2 varchar(9)
DECLARE @CSSalesInstrument_Type2 varchar(6)
DECLARE @CSSalesValidity_Code2 char(2)
DECLARE @CSSalesType_Code2 char(1)
DECLARE @CSSales_Price2 varchar(10)
DECLARE @CSSales_Book3 varchar(5)
DECLARE @CSSales_Page3 varchar(50)
DECLARE @CSSales_Date3 varchar(9)
DECLARE @CSSalesInstrument_Type3 varchar(6)
DECLARE @CSSalesValidity_Code3 char(2)
DECLARE @CSSalesType_Code3 char(1)
DECLARE @CSSales_Price3 varchar(10)
DECLARE @CSSales_Book4 varchar(5)
DECLARE @CSSales_Page4 varchar(50)
DECLARE @CSSales_Date4 varchar(9)
DECLARE @CSSalesInstrument_Type4 varchar(6)
DECLARE @CSSalesValidity_Code4 char(2)
DECLARE @CSSalesType_Code4 char(1)
DECLARE @CSSales_Price4 varchar(10)
DECLARE @CSSales_Book5 varchar(5)
DECLARE @CSSales_Page5 varchar(50)
DECLARE @CSSales_Date5 varchar(9)
DECLARE @CSSalesInstrument_Type5 varchar(6)
DECLARE @CSSalesValidity_Code5 char(2)
DECLARE @CSSalesType_Code5 char(1)
DECLARE @CSSales_Price5 varchar(10)
SET NOCOUNT ON
DECLARE curCS CURSOR
FOR select Sales_Book1,Sales_Page1,Sales_Date1,SalesInstrument_Type1,SalesValidity_Code1,SalesType_Code1,Sales_Price1,
Sales_Book2,Sales_Page2,Sales_Date2,SalesInstrument_Type2,SalesValidity_Code2,SalesType_Code2,Sales_Price2,
Sales_Book3,Sales_Page3,Sales_Date3,SalesInstrument_Type3,SalesValidity_Code3,SalesType_Code3,Sales_Price3,
Sales_Book4,Sales_Page4,Sales_Date4,SalesInstrument_Type4,SalesValidity_Code4,SalesType_Code4,Sales_Price4,
Sales_Book5,Sales_Page5,Sales_Date5,SalesInstrument_Type5,SalesValidity_Code5,SalesType_Code5,Sales_Price5,pcn
from rd_tbl_cama_sales cs where cs.pcn = @CSSPCN
FOR UPDATE OF Sales_Book1,Sales_Page1,Sales_Date1,SalesInstrument_Type1,SalesValidity_Code1,SalesType_Code1,
Sales_Price1,Sales_Book2,Sales_Page2,Sales_Date2,SalesInstrument_Type2,SalesValidity_Code2,
SalesType_Code2,Sales_Price2,Sales_Book3,Sales_Page3,Sales_Date3,SalesInstrument_Type3,
SalesValidity_Code3,SalesType_Code3,Sales_Price3,Sales_Book4,Sales_Page4,Sales_Date4,
SalesInstrument_Type4,SalesValidity_Code4,SalesType_Code4,Sales_Price4,Sales_Book5,
Sales_Page5,Sales_Date5,SalesInstrument_Type5,SalesValidity_Code5,SalesType_Code5,Sales_Price5,pcn
DECLARE curCSS CURSOR
FOR select Sales_Book1,Sales_Page1,Sales_Date1,SalesInstrument_Type1,SalesValidity_Code1,
SalesType_Code1,Sales_Price1,Sales_Book2,Sales_Page2,Sales_Date2,SalesInstrument_Type2,
SalesValidity_Code2,SalesType_Code2,Sales_Price2,Sales_Book3,Sales_Page3,Sales_Date3,
SalesInstrument_Type3,SalesValidity_Code3,SalesType_Code3,Sales_Price3,Sales_Book4,Sales_Page4,
Sales_Date4,SalesInstrument_Type4,SalesValidity_Code4,SalesType_Code4,Sales_Price4,
Sales_Book5,Sales_Page5,Sales_Date5,SalesInstrument_Type5,SalesValidity_Code5,SalesType_Code5,
Sales_Price5,pcn from rd_tbl_cama_sales_staging css
OPEN curCSS
OPEN curCS
FETCH NEXT FROM curCSS INTO @CSSSales_Book1,@CSSSales_Page1,@CSSSales_Date1,@CSSSalesInstrument_Type1,
@CSSSalesValidity_Code1,@CSSSalesType_Code1,@CSSSales_Price1,@CSSSales_Book2,
@CSSSales_Page2,@CSSSales_Date2,@CSSSalesInstrument_Type2,@CSSSalesValidity_Code2,
@CSSSalesType_Code2,@CSSSales_Price2,@CSSSales_Book3,@CSSSales_Page3,@CSSSales_Date3,
@CSSSalesInstrument_Type3,@CSSSalesValidity_Code3,@CSSSalesType_Code3,@CSSSales_Price3,
@CSSSales_Book4,@CSSSales_Page4,@CSSSales_Date4,@CSSSalesInstrument_Type4,
@CSSSalesValidity_Code4,@CSSSalesType_Code4,@CSSSales_Price4,@CSSSales_Book5,
@CSSSales_Page5,@CSSSales_Date5,@CSSSalesInstrument_Type5,@CSSSalesValidity_Code5,
@CSSSalesType_Code5,@CSSSales_Price5,@csspcn
WHILE (@@fetch_status = 0)
BEGIN
FETCH NEXT FROM curCS INTO @csSales_Book1,@csSales_Page1,@csSales_Date1,@csSalesInstrument_Type1,@csSalesValidity_Code1,
@csSalesType_Code1,@csSales_Price1,@csSales_Book2,@csSales_Page2,@csSales_Date2,
@csSalesInstrument_Type2,@csSalesValidity_Code2,@csSalesType_Code2,@csSales_Price2,
@csSales_Book3,@csSales_Page3,@csSales_Date3,@csSalesInstrument_Type3,
@csSalesValidity_Code3,@csSalesType_Code3,@csSales_Price3,@csSales_Book4,@csSales_Page4,
@csSales_Date4,@csSalesInstrument_Type4,@csSalesValidity_Code4,@csSalesType_Code4,
@csSales_Price4,@csSales_Book5,@csSales_Page5,@csSales_Date5,@csSalesInstrument_Type5,
@csSalesValidity_Code5,@csSalesType_Code5,@csSales_Price5,@cspcn
WHILE (@@fetch_status = 0)
BEGIN
IF (@cssSales_Date1 > @csSales_Date1)
BEGIN
IF (@cssSales_Date2 = @csSales_Date1)
BEGIN
UPDATE RD_tbl_CAMA_Sales
SET Sales_Book5= Sales_Book4,
Sales_Page5=Sales_Page4,
Sales_Date5=Sales_Date4,
SalesInstrument_Type5=SalesInstrument_Type4,
SalesValidity_Code5=SalesValidity_Code4,
SalesType_Code5=SalesType_Code4,
Sales_Price5=Sales_Price4,
Sales_Book4=Sales_Book3,
Sales_Page4=Sales_Page3,
Sales_Date4=Sales_Date3,
SalesInstrument_Type4=SalesInstrument_Type3,
SalesValidity_Code4=SalesValidity_Code3,
SalesType_Code4=SalesType_Code3,
Sales_Price4=Sales_Price3,
Sales_Book3=Sales_Book2,
Sales_Page3=Sales_Page2,
Sales_Date3=Sales_Date2,
SalesInstrument_Type3=SalesInstrument_Type2,
SalesValidity_Code3=SalesValidity_Code2,
SalesType_Code3=SalesType_Code2,
Sales_Price3=Sales_Price2,
Sales_Book2=Sales_Book1,
Sales_Page2=Sales_Page1,
Sales_Date2=Sales_Date1,
SalesInstrument_Type2=SalesInstrument_Type1,
SalesValidity_Code2=SalesValidity_Code1,
SalesType_Code2=SalesType_Code1,
Sales_Price2=Sales_Price1,
Sales_Book1=@CSSSales_Book1,
Sales_Page1=@CSSSales_Page1,
Sales_Date1=@CSSSales_Date1,
SalesInstrument_Type1=@cssSalesInstrument_Type1,
SalesValidity_Code1=@CSSSalesValidity_Code1,
SalesType_Code1=@CSSSalesType_Code1,
Sales_Price1=@CSSSales_Price1 where CURRENT OF curCS
FETCH NEXT FROM curCS INTO @csSales_Book1,@csSales_Page1,@csSales_Date1,@csSalesInstrument_Type1,@csSalesValidity_Code1,@csSalesType_Code1,@csSales_Price1,
@csSales_Book2,@csSales_Page2,@csSales_Date2,@csSalesInstrument_Type2,@csSalesValidity_Code2,@csSalesType_Code2,@csSales_Price2,
@csSales_Book3,@csSales_Page3,@csSales_Date3,@csSalesInstrument_Type3,@csSalesValidity_Code3,@csSalesType_Code3,@csSales_Price3,
@csSales_Book4,@csSales_Page4,@csSales_Date4,@csSalesInstrument_Type4,@csSalesValidity_Code4,@csSalesType_Code4,@csSales_Price4,
@csSales_Book5,@csSales_Page5,@csSales_Date5,@csSalesInstrument_Type5,@csSalesValidity_Code5,@csSalesType_Code5,@csSales_Price5,@cspcn
if (@CSSSales_date5 <> NULL) begin Insert into RD_tbl_AA_HistoricSales ( PCN,Property_Use, Name,AddrLine1,AddrLine2,AddrLine3,SaleDate,SalePrice,Book,Page, Situs_City) SELECT @CSPCN,P.Land_UseCode,CO.Owner_Name,CO.Addr_Line1,CO.Addr_Line2,CO.Addr_Line3, @CSSales_Date5,
@CSSales_Price5,@CSSales_Book5,@CSSales_Page5, SUBSTRING(@csPCN, 1, 2)
from RD_tbl_CAMA_Owner CO Inner Join RD_tbl_CAMA_Parcel P on CO.PCN=P.PCN
where CO.PCN = @CSPCN
end
END
ELSE IF(@cssSales_Date3 = @csSales_Date1)
BEGIN
UPDATE RD_tbl_CAMA_Sales SET
Sales_Book5=Sales_Book3,
Sales_Page5=Sales_Page3,
Sales_Date5=Sales_Date3,
SalesInstrument_Type5=SalesInstrument_Type3,
SalesValidity_Code5=SalesValidity_Code3,
SalesType_Code5=SalesType_Code3,
Sales_Price5=Sales_Price3,
Sales_Book4=Sales_Book2,
Sales_Page4=Sales_Page2,
Sales_Date4=Sales_Date2,
SalesInstrument_Type4=SalesInstrument_Type2,
SalesValidity_Code4=SalesValidity_Code2,
SalesType_Code4=SalesType_Code2,
Sales_Price4=Sales_Price2,
Sales_Book3=Sales_Book1,
Sales_Page3=Sales_Page1,
Sales_Date3=Sales_Date1,
SalesInstrument_Type3=SalesInstrument_Type1,
SalesValidity_Code3=SalesValidity_Code1,
SalesType_Code3=SalesType_Code1,
Sales_Price3=Sales_Price1,
Sales_Book2=@CSSSales_Book2,
Sales_Page2=@CSSSales_Page2,
Sales_Date2=@CSSSales_Date2,
SalesInstrument_Type2=@CSSSalesInstrument_Type2,
SalesValidity_Code2=@CSSSalesValidity_Code2,
SalesType_Code2=@CSSSalesType_Code2,
Sales_Price2=@CSSSales_Price2,
Sales_Book1=@CSSSales_Book1,
Sales_Page1=@CSSSales_Page1,
Sales_Date1=@CSSSales_Date1,
SalesInstrument_Type1=@CSSSalesInstrument_Type1,
SalesValidity_Code1=@CSSSalesValidity_Code1,
SalesType_Code1=@CSSSalesType_Code1,
Sales_Price1=@CSSSales_Price1
where CURRENT OF curCS
FETCH NEXT FROM curCS INTO @csSales_Book1,@csSales_Page1,@csSales_Date1,@csSalesInstrument_Type1,@csSalesValidity_Code1,@csSalesType_Code1,@csSales_Price1,
@csSales_Book2,@csSales_Page2,@csSales_Date2,@csSalesInstrument_Type2,@csSalesValidity_Code2,@csSalesType_Code2,@csSales_Price2,
@csSales_Book3,@csSales_Page3,@csSales_Date3,@csSalesInstrument_Type3,@csSalesValidity_Code3,@csSalesType_Code3,@csSales_Price3,
@csSales_Book4,@csSales_Page4,@csSales_Date4,@csSalesInstrument_Type4,@csSalesValidity_Code4,@csSalesType_Code4,@csSales_Price4,
@csSales_Book5,@csSales_Page5,@csSales_Date5,@csSalesInstrument_Type5,@csSalesValidity_Code5,@csSalesType_Code5,@csSales_Price5,@cspcn
if (@CSSSales_date5 <> NULL) begin Insert into RD_tbl_AA_HistoricSales ( PCN,Property_Use, Name,AddrLine1,AddrLine2,AddrLine3,SaleDate,SalePrice,Book,Page, Situs_City) SELECT @CSPCN,P.Land_UseCode,CO.Owner_Name,CO.Addr_Line1,CO.Addr_Line2,CO.Addr_Line3, @CSSales_Date5,
@CSSales_Price5,@CSSales_Book5,@CSSales_Page5, SUBSTRING(@csPCN, 1, 2)
from RD_tbl_CAMA_Owner CO Inner Join RD_tbl_CAMA_Parcel P on CO.PCN=P.PCN
where CO.PCN = @CSPCN
end
if (@CSSSales_date4 <> NULL) begin Insert into RD_tbl_AA_HistoricSales ( PCN,Property_Use, Name,AddrLine1,AddrLine2,AddrLine3,SaleDate,SalePrice,Book,Page, Situs_City) SELECT @CSPCN,P.Land_UseCode,CO.Owner_Name,CO.Addr_Line1,CO.Addr_Line2,CO.Addr_Line3, @CSSales_Date4,
@CSSales_Price4,@CSSales_Book4,@CSSales_Page4, SUBSTRING(@csPCN, 1, 2)
from RD_tbl_CAMA_Owner CO Inner Join RD_tbl_CAMA_Parcel P on CO.PCN=P.PCN
where CO.PCN = @CSPCN
end
END
ELSE IF(@cssSales_Date4 = @csSales_Date1)
BEGIN
UPDATE RD_tbl_CAMA_Sales
SET sales_book5=Sales_Book2,
Sales_Page5=Sales_Page2,
Sales_Date5=Sales_Date2,
SalesInstrument_Type5=SalesInstrument_Type2,
SalesValidity_Code5=SalesValidity_Code2,
SalesType_Code5=SalesType_Code2,
Sales_Price5=Sales_Price2,
Sales_Book4=Sales_Book1,
Sales_Page4=Sales_Page1,
Sales_Date4=Sales_Date1,
SalesInstrument_Type4=SalesInstrument_Type1,
SalesValidity_Code4=SalesValidity_Code1,
SalesType_Code4=SalesType_Code1,
Sales_Price4=Sales_Price1,
Sales_Book3=@cssSales_Book3,
Sales_Page3=@cssSales_Page3,
Sales_Date3=@cssSales_Date3,
SalesInstrument_Type3=@cssSalesInstrument_Type3,
SalesValidity_Code3=@cssSalesValidity_Code3,
SalesType_Code3=@cssSalesType_Code3,
Sales_Price3=@cssSales_Price3,
Sales_Book2=@cssSales_Book2,
Sales_Page2=@cssSales_Page2,
Sales_Date2=@cssSales_Date2,
SalesInstrument_Type2=@cssSalesInstrument_Type2,
SalesValidity_Code2=@cssSalesValidity_Code2,
SalesType_Code2=@cssSalesType_Code2,
Sales_Price2=@cssSales_Price2,
Sales_Book1=@cssSales_Book1,
Sales_Page1=@cssSales_Page1,
Sales_Date1=@cssSales_Date1,
SalesInstrument_Type1=@cssSalesInstrument_Type1,
SalesValidity_Code1=@cssSalesValidity_Code1,
SalesType_Code1=@cssSalesType_Code1,
Sales_Price1=@cssSales_Price1 where CURRENT OF curCS
FETCH NEXT FROM curCS INTO @csSales_Book1,@csSales_Page1,@csSales_Date1,@csSalesInstrument_Type1,@csSalesValidity_Code1,@csSalesType_Code1,@csSales_Price1,
@csSales_Book2,@csSales_Page2,@csSales_Date2,@csSalesInstrument_Type2,@csSalesValidity_Code2,@csSalesType_Code2,@csSales_Price2,
@csSales_Book3,@csSales_Page3,@csSales_Date3,@csSalesInstrument_Type3,@csSalesValidity_Code3,@csSalesType_Code3,@csSales_Price3,
@csSales_Book4,@csSales_Page4,@csSales_Date4,@csSalesInstrument_Type4,@csSalesValidity_Code4,@csSalesType_Code4,@csSales_Price4,
@csSales_Book5,@csSales_Page5,@csSales_Date5,@csSalesInstrument_Type5,@csSalesValidity_Code5,@csSalesType_Code5,@csSales_Price5,@cspcn
if (@CSSSales_date5 <> NULL) begin Insert into RD_tbl_AA_HistoricSales ( PCN,Property_Use, Name,AddrLine1,AddrLine2,AddrLine3,SaleDate,SalePrice,Book,Page, Situs_City) SELECT @CSPCN,P.Land_UseCode,CO.Owner_Name,CO.Addr_Line1,CO.Addr_Line2,CO.Addr_Line3, @CSSales_Date5,
@CSSales_Price5,@CSSales_Book5,@CSSales_Page5, SUBSTRING(@csPCN, 1, 2)
from RD_tbl_CAMA_Owner CO Inner Join RD_tbl_CAMA_Parcel P on CO.PCN=P.PCN
where CO.PCN = @CSPCN
end
if (@CSSSales_date4 <> NULL) begin Insert into RD_tbl_AA_HistoricSales ( PCN,Property_Use, Name,AddrLine1,AddrLine2,AddrLine3,SaleDate,SalePrice,Book,Page, Situs_City) SELECT @CSPCN,P.Land_UseCode,CO.Owner_Name,CO.Addr_Line1,CO.Addr_Line2,CO.Addr_Line3, @CSSales_Date4,
@CSSales_Price4,@CSSales_Book4,@CSSales_Page4, SUBSTRING(@csPCN, 1, 2)
from RD_tbl_CAMA_Owner CO Inner Join RD_tbl_CAMA_Parcel P on CO.PCN=P.PCN
where CO.PCN = @CSPCN
end
if (@CSSSales_date3 <> NULL) BEGIN Insert into RD_tbl_AA_HistoricSales ( PCN,Property_Use, Name,AddrLine1,AddrLine2,AddrLine3,SaleDate,SalePrice,Book,Page, Situs_City) SELECT @CSPCN,P.Land_UseCode,CO.Owner_Name,CO.Addr_Line1,CO.Addr_Line2,CO.Addr_Line3, @CSSales_Date3,
@CSSales_Price3,@CSSales_Book3,@CSSales_Page3, SUBSTRING(@csPCN, 1, 2)
from RD_tbl_CAMA_Owner CO Inner Join RD_tbl_CAMA_Parcel P on CO.PCN=P.PCN
where CO.PCN = @CSPCN
END
END
END
set @CSPCN =null
set @CSSales_Book1 =null
set @CSSales_Page1 =null
set @CSSales_Date1 =null
set @CSSalesInstrument_Type1 =null
set @CSSalesValidity_Code1 =null
set @CSSalesType_Code1 =null
set @CSSales_Price1 =null
set @CSSales_Book2 =null
set @CSSales_Page2 =null
set @CSSales_Date2 =null
set @CSSalesInstrument_Type2 =null
set @CSSalesValidity_Code2 =null
set @CSSalesType_Code2 =null
set @CSSales_Price2 =null
set @CSSales_Book3 =null
set @CSSales_Page3 =null
set @CSSales_Date3 =null
set @CSSalesInstrument_Type3 =null
set @CSSalesValidity_Code3 =null
set @CSSalesType_Code3 =null
set @CSSales_Price3 =null
set @CSSales_Book4 =null
set @CSSales_Page4 =null
set @CSSales_Date4 =null
set @CSSalesInstrument_Type4 =null
set @CSSalesValidity_Code4 =null
set @CSSalesType_Code4 =null
set @CSSales_Price4 =null
set @CSSales_Book5 =null
set @CSSales_Page5 =null
set @CSSales_Date5 =null
set @CSSalesInstrument_Type5 =null
set @CSSalesValidity_Code5 =null
set @CSSalesType_Code5 =null
set @CSSales_Price5 =null
END
set @CSSPCN =null
set @CSSSales_Book1 =null
set @CSSSales_Page1 =null
set @CSSSales_Date1 =null
set @CSSSalesInstrument_Type1 =null
set @CSSSalesValidity_Code1 =null
set @CSSSalesType_Code1 =null
set @CSSSales_Price1 =null
set @CSSSales_Book2 =null
set @CSSSales_Page2 =null
set @CSSSales_Date2 =null
set @CSSSalesInstrument_Type2 =null
set @CSSSalesValidity_Code2 =null
set @CSSSalesType_Code2 =null
set @CSSSales_Price2 =null
set @CSSSales_Book3 =null
set @CSSSales_Page3 =null
set @CSSSales_Date3 =null
set @CSSSalesInstrument_Type3 =null
set @CSSSalesValidity_Code3 =null
set @CSSSalesType_Code3 =null
set @CSSSales_Price3 =null
set @CSSSales_Book4 =null
set @CSSSales_Page4 =null
set @CSSSales_Date4 =null
set @CSSSalesInstrument_Type4 =null
set @CSSSalesValidity_Code4 =null
set @CSSSalesType_Code4 =null
set @CSSSales_Price4 =null
set @CSSSales_Book5 =null
set @CSSSales_Page5 =null
set @CSSSales_Date5 =null
set @CSSSalesInstrument_Type5 =null
set @CSSSalesValidity_Code5 =null
set @CSSSalesType_Code5 =null
set @CSSSales_Price5 =null
FETCH NEXT FROM curCSS INTO @CSSSales_Book1,@CSSSales_Page1,@CSSSales_Date1,@CSSSalesInstrument_Type1,@CSSSalesValidity_Code1,@CSSSalesType_Code1,@CSSSales_Price1,
@CSSSales_Book2,@CSSSales_Page2,@CSSSales_Date2,@CSSSalesInstrument_Type2,@CSSSalesValidity_Code2,@CSSSalesType_Code2,@CSSSales_Price2,
@CSSSales_Book3,@CSSSales_Page3,@CSSSales_Date3,@CSSSalesInstrument_Type3,@CSSSalesValidity_Code3,@CSSSalesType_Code3,@CSSSales_Price3,
@CSSSales_Book4,@CSSSales_Page4,@CSSSales_Date4,@CSSSalesInstrument_Type4,@CSSSalesValidity_Code4,@CSSSalesType_Code4,@CSSSales_Price4,
@CSSSales_Book5,@CSSSales_Page5,@CSSSales_Date5,@CSSSalesInstrument_Type5,@CSSSalesValidity_Code5,@CSSSalesType_Code5,@CSSSales_Price5,@csspcn
END
CLOSE curCS
CLOSE curCSS
DEALLOCATE curCS
DEALLOCATE curCSS
end