reading data from table and print the value based condition

[Former Member]

hi

my table like this

slno | value1 | value2 |

-

---

1 0 5

2 5 10

3 10 15

assume n= 8 ( where n is user define)

i want output like

number 8 between value 5 and 10

plz help

[Former Member · Accepted solution]

Hi,

Try:

Select 'Number '+ U_Value3 + ' Between '+ U_Value1'and 'U_Value2

From [dbo\].[@UDT T0\]

Where T0.U_Value3=[%0\] and T0.U_Value3 BETWEEN U_Value1 AND U_Value2

Thanks,

Gordon

[Former Member · Accepted solution]

thanks to all