Stored Procedure to return values from x to y with increment z
Posted on 2003-11-15
This is simple (I think), just have not done anything like it yet
If a table has values x, y, and z
(where x is "low value", y is High value" and z is "increment")
in a row I am calling with variable "a", how do I return a set of rows that start with x, end with y, and move upwards with the increment z?
for example, x=2, y=10, z=2
the stored procedure returns
thanks! It is urgent I learn this asap to forward my project.