return data from sql table

Question

hi

i have a table below like :

id   sNumber        eNumber

1    1500               1999

2    2000               2499

3   2500               3000

now how to i return id row 2200

please help me

thanks 

Answer 1

are you looking for something like this

declare @tab Table
(id int, sNumber int, eNumber int)

insert into @tab values
(1,1500, 1999),
(2 , 2000 ,2499),
(3, 2500 ,3000)

select * from @tab
where id=3 -- any id 

Regards
Satheeseh

Answer 2

thanks for your answer

no,it'snot my means

i have 2 range (sNumber , eNumber)

and i have a value fro example (2400)

now must return id 2 from table

please help me

thanks

Answer 3

Okay, it was not that clear initially :-(

 Assuming eNumber will be higher always

declare @tab Table
(id int, sNumber int, eNumber int)

insert into @tab values
(1,1500, 1999),
(2 , 2000 ,2499),
(3, 2500 ,3000)


declare @idtofind int=2400;
select * from @tab t
where @idtofind between t.sNumber and  t.eNumber 

Reagrds
Satheesh

Answer 4

Hi

You can also  use table valued function .

 In Put data :

Create table tblIdInfo
(
	id int PRIMARY KEY NOT NULL,
	sNumber int,
	eNumber int
)

insert into tblIdInfo values 
(1 ,   1500    ,           1999),
(2  ,  2000       ,        2499),
(3  , 2500       ,        3000)

Make function:

Create FUNCTION [dbo].[udf_GetRows] (@sNumber INT, @eNumber INT)

/* 
--Created By Ahsan kabir

--Execution
SELECT * FROM [udf_GetRows] (2,3)
*/

RETURNS @tblResult TABLE
(
 
	id int PRIMARY KEY NOT NULL,
	sNumber int,
	eNumber int
)   
AS
begin
	insert into @tblResult
	Select *   from tblIdInfo where id between @sNumber and  eNumber 
RETURN

End

---

Ahsan Kabir Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread. http://www.aktechforum.blogspot.com/

Answer 5

Hi vahidbakhtiary,

you can do like this

select id from myTable
where myvalue between sNumber and eNumber