Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nalin_769
Starting Member
16 Posts |
 Posted - 2008-02-27 : 00:51:28
|
| I have a table call MAS_QTYRNG and fields are QTYCode, QtyRngFrom, QtyRngTo.Ex: QTYCode QtyRngFrom QtyRngTo 1 2000 3000 2 3001 4000 3 4001 5000 How I specify sql query to get QTYCode vaue between QtyRngFrom and QtyRngTo. Given value will be 2500.Thank You |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-02-27 : 02:03:28
|
SELECT * FROM MAS_QTYRNGWHERE @MySearchValue BETWEEN QtyRngFrom AND QtyRngTo
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-02-27 : 02:12:32
|
| orSELECT * FROM MAS_QTYRNGWHERE QtyRngFrom<=@MySearchValue AND QtyRngTo>=@MySearchValueMadhivananFailing to plan is Planning to fail |
|
|
|
nalin_769
Starting Member
16 Posts |
Posted - 2008-02-27 : 02:26:24
|
| Peso thank you for the reply. It works. |
|
|
|
|
|
|
Get a record between 2 fields