Re: Dynamic and Static Query. Cursor

Good grief. Could you mis-align your code any more? A little organization and aligning goes a long way when looking at code.

Drop all those useless and confusing parentheses in the final where clause. All you need is:
WHERE XNUM BETWEEN V_PAGE_SIZE * (V_PAGE_NO-1) + 1                AND V_PAGE_SIZE * V_PAGE_NO And add a final Order-by clause:
  ORDER BY XNUM Received on Fri Jan 27 2006 - 13:03:40 CST