select Item between two value

nedash

SOLVED CLOSED ACTIVE ANSWERED
User: nedash
Posted: on Sep 23, 2013 02:16 AM
Forum: SQL Server
Answer: 1
Views: 2283

Below is Behcode table in database

date	reserved	Behcode	id
NULL	NO	1000	1
Null	NO	1001	2
2013-4-5	yes	1002	3
2013-5-8	yes	1003	4
Null	NO	1004	5
Null	NO	1005	6

I have button in Information.aspx page

that when I click on this button it bind datalist from Information table

I want in datalist show data from above table that Reserved column is=NO that are before last DATE entered

i.e

here should show data with id =1,2 these id Reserved column's is NO and are before id=4 that date column date is=2013-5-8 it shouldn't show id=5,6 becuse these are after 2013-5-8

in SP what should I write...

Best Regards

NEDA

Download FREE API for Word, Excel and PDF in ASP.Net

kalpesh

0 1

Reply
ANSWER
User: kalpesh
Replied: on Sep 23, 2013 02:44 AM
Report

You Must Check Max Id of Behcode Table whoes Date Is Not Null

In sub query also Check the reserve Colum value as NO in Main Query

-- EXEC GETBehcodeDetails
CREATE PROCEDURE GETBehcodeDetails
AS 
BEGIN
	SELECT Behcode.ID
		  ,Behcode.Behcode
		  ,Behcode.reserved
		  ,[Date]
	From Behcode  Behcode 
	WHERE Behcode.reserved='NO' 
	AND  Behcode.Id<=(SELECT  MAX(Id) From Behcode
					  WHERE [DATE] Is Not Null)
END
GO

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

select Item between two value

Company

Explore

Follow us

Contact Us