hi expert,
I have a problem with seeking to date,
This Query me ..
SET ARITHABORT OFF SET ANSI_WARNINGS OFF
SELECT T0.Project, T0.U_Hotel, COUNT(T0.U_Hotel) AS 'Qty Hotel'
DAY(GetDate()) as 'Days',
Case WHEN Month(GetDate()) in (1,3,5,7,8,10,12) THEN 31 WHEN Month(GetDate()) in (2,4,6,9,11) THEN 30 ELSE 28 END AS 'Total days'
FROM DBO.OINV T0
WHERE
T0.Project >= '[%0]' AND T0.Project <= '[%1]'AND
T0.U_Hotel >= '[%2]' AND T0.U_Hotel <= '[%3]'AND
DAY(GetDate())as 'Days'>= '[%4]' AND DAY(GetDate())as 'Days' <= '[%5]'
Group By T0.Project, T0.U_Hotel
invented that can help me ..
so it will look like this:
ProjectCode, Hotel, Total Hotel, Days, Total Days
A,XXX,10, 26, 30
thx for all