Skip to Content
0
Former Member
Nov 26, 2009 at 02:48 AM

Query DAYS

38 Views

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