Date

[chaya]

hi,
there is one table which is having one field for date i.e. tdate, now i want to display those records for which i have given the date span e.g. if i enter date span 01/08/2005 - 15/08/2005 in the form, then i want all the records containing these dates, if any date between this date span missing means not present in table then it should not display any record.

plz help me

[Shaunt]

create table test (a datetime,b int) -- b is the sample for data you can have as menay data sa you wantgo

create function dbo.test_fn (@from_date datetime,@to_date datetime)
returns char
as
begin
declare @flag char,@main_count int,@count int
select @flag='N'
select @main_count=count(*) from test
select @count=count(*) from test where a between @from_date and @to_date
if (@count=@main_count) set @flag= 'Y'
return @flag
end

go

select * from test where dbo.test_fn( '2005-05-01', '2005-05-05')='Y'

It will display the result only if the dates given cover all the data in the table.