Comparing a value in between two columns

I have a table TblControl. Data type of both field is int.

StartRange End Range

BMIClassification Table

startval endvalue

0 100
200 300
500 600
900 950

SELECT StartRange, EndRange
FROM Control
WHERE 225 BETWEEN StartRange AND EndRange

eg:-
Declare @BMIValue int

set @BMIValue=34

SELECT * FROM BMIClassification
WHERE @BMIValue between startval and endvalue

 

 

Comments

Post a Comment

Popular posts from this blog

How to insert multiple rows from c# table to sql database table:- Frontend:   <asp:Button ID="Button2" runat="server" Text="Create Table"             onclick="Button2_Click" /> <asp:GridView ID="gveg" runat="server">         </asp:GridView> Backend C#:  protected void Button2_Click(object sender, EventArgs e)     {         //         // Here we create a DataTable with four columns.         //                 DataTable temptable = new DataTable();         temptable.Columns.Add("ProductID", typeof(string));         temptable.Columns.Add("RelatedProductID", typeof(string));         temptable.Columns.Add("IsActive", typeof(string));         foreach (ListItem item in ListBox1.Items)         {             if (item.Selected)             {                 //                 // Here we add five DataRows.                 //                 temptable.Rows.Add(1, 1, 1);             }
Read more
make round corner that support in IE Also http://cssround.com/ Give Button css http://css-tricks.com/ examples/ButtonMaker/
Read more