Wednesday, 21 August 2013

The number of variables declared in the INTO list must match that of selected columns

The number of variables declared in the INTO list must match that of
selected columns

I have checked over this several times. The column count matches yet I
keep getting an error saying the fetch into statement does not match the
count
declare cur_range CURSOR FOR
SELECT
GroupID,
OddEven,
RangeLow,
RangeHigh
PostCode1,
PostCode2,
ID,
OldPrimaryID,
ThFareID
FROM tmpNewPrimaryRange;
OPEN cur_range
FETCH NEXT FROM cur_range
into
@cur_GroupID
, @cur_OddEven
, @cur_RangeLow
, @cur_RangeHigh
, @cur_PostCode1
, @cur_PostCode2
, @cur_ID
, @cur_OldPrimaryID
, @cur_ThFareID

No comments:

Post a Comment