hi every one. I'm facing a problem before last 10 days i try many time but i found No solution.
I'm developing a Restaurant POS .
and Now i make report for Daily Sale i'm facing a problem in a SQL query that get data for daily sale.
My Restaurant is opening time is 13:00 and Closing time is 04:00 of Tomorrow.
just like that
Opening date & time is =14.08.2019 & 13:00
Closing date & Time is =15.08.2019 & 04:00
We have 24 hours Time format.
I'm trying this SQL Query. But i always get result
Total sale=0.00
Please Help me
What I have tried:
ALTER procedure [dbo].[USP_Select_sale_Baseon_Employee]
(
@Emid int,
@Dateofbil datetime,
@Todate datetime,
@Fromtime time(7),
@Endtime time(7)
)
as
begin
SELECT
coalesce(sum( c.[Receableamount]),0) as 'recevable'
FROM [dbo].[Customer_Bill_Details] c
where [EmID]=@Emid and [Billdate]>=@Dateofbil and BillTime>=@Fromtime and [Billdate]<=@Todate and BillTime<=@Endtime
end