create table #fueldt
(
[id] [int] identity(1,1) not null,
[vendorname] [nvarchar](50) null,
[fromdate] [datetime],
[todate] [datetime],
[fuelprice] [decimal] (18,2)
)
go
insert into #fueldt ([vendorname], [fromdate], [todate],[fuelprice]) values (n'vendor1', getdate()-23, getdate(),78)
insert into #fueldt ([vendorname], [fromdate], [todate],[fuelprice]) values (n'vendor2', getdate()-13, getdate(),72)
insert into #fueldt ([vendorname], [fromdate], [todate],[fuelprice]) values (n'vendor3', getdate()-18, getdate(),75)
go
select
*
from #fueldt fuel
where (
convert(date,'7 feb 2020') between convert(date,fuel.fromdate) and convert(date,fuel.todate)
)
select * from #fueldt
(
[id] [int] identity(1,1) not null,
[vendorname] [nvarchar](50) null,
[fromdate] [datetime],
[todate] [datetime],
[fuelprice] [decimal] (18,2)
)
go
insert into #fueldt ([vendorname], [fromdate], [todate],[fuelprice]) values (n'vendor1', getdate()-23, getdate(),78)
insert into #fueldt ([vendorname], [fromdate], [todate],[fuelprice]) values (n'vendor2', getdate()-13, getdate(),72)
insert into #fueldt ([vendorname], [fromdate], [todate],[fuelprice]) values (n'vendor3', getdate()-18, getdate(),75)
go
select
*
from #fueldt fuel
where (
convert(date,'7 feb 2020') between convert(date,fuel.fromdate) and convert(date,fuel.todate)
)
select * from #fueldt
0 Comments