DECLARE DistiUploadIns_Cursor CURSOR LOCAL FAST_FORWARD FOR

SELECT     a.ins_id, 
           a.frcst_altr_id, 
           wh.wh_id, 
           b.ins_1st_cnt_dt, 
           b.ins_2nd_cnt_dt, 
           b.ins_st_cnt_dt, 
           b.ins_pos_cnt_dt 
FROM       ins_product AS a INNER JOIN ins_country as b 
            ON a.ins_id = b.ins_id, 
           warehouse as wh
WHERE      a.ins_id = @insId and 
           b.disti_ctry_id = @ctryId and 
           wh.disti_id = @disti_id and 
           wh_inactive_flag ='T' 
           and (ins_1st_cnt_dt <> '' or 
                ins_2nd_cnt_dt <> '' or 
                ins_2nd_cnt_dt <> '' or 
                ins_pos_cnt_dt <> ''
                )

OPEN DistiUploadIns_Cursor

FETCH NEXT 
FROM       DistiUploadIns_Cursor 
INTO       @ins_id,
           @frcst_altr_id,
           @WH_ID, 
           @1SC_Type, 
           @2SC_Type, 
           @SC_ype, 
           @POS_Type

DECLARE @tmpTable table (RowID int IDENTITY(1, 1), ins_id int, frcst_altr_id int ...)
DECLARE @Counter int
SET @Counter = 0

INSERT INTO @tmpTable
SELECT blahblah (same select as when declaring the cursor)

WHILE (@Counter <= (SELECT MAX(RowID) FROM @tmpTable))
  BEGIN
    SELECT @ins_id = ins_id, @frcst_altr_id = frcst_altr_id, ...
    FROM @tmptable
    WHERE RowID = @Counter

    --> Do your row-by-row stuff

    SET @Counter = @Counter + 1
  END