...INTO @tierId, @tierItem, @tierQty, @tierAmt
WHILE (@@FETCH_STATUS = 0)
BEGIN
INSERT @tmpTable
SELECT @tierId, @tierItem, @tierQty, @tierAmt
FETCH NEXT FROM myCursor INTO @tierId, @tierItem, @tierQty, @tierAmt
END /*WHILE*/
CLOSE myCursor
DEALLOCATE myCursor
RETURN
END
[\CODE]