I have a table and data stored as follows
ID MIN MAX VALUE
1 0 15 25
1 16 30 50
1 31 45 75
1 46 300 100
I have a value called x
x = 35
Now I need to find out a way to find that x is basically in which slot. I'm not using SQL statesments in my code. Only storedprocudures.
please let me know the best way it.
Currently what I did was
I have a function and I'm passing the x value to it and there I'm getting those records into a recordset and in a for loop I'm checking the no is exist or not.
I need a better way of doing it