-- My Time Today
SELECT ISNULL(SUM(Hours_Actual),0)
FROM v_TimeRecords
WHERE Member_ID = SUBSTRING(SYSTEM_USER,CHARINDEX('\',SYSTEM_USER)+1,LEN(SYSTEM_USER)-CHARINDEX('\',SYSTEM_USER))
AND Date_Start = DATEADD(Day, 0, DATEDIFF(Day, 0, GETDATE()))
-- My Time This Week
SELECT ISNULL(SUM(Hours_Actual),0)
FROM v_TimeRecords
WHERE Member_ID = SUBSTRING(SYSTEM_USER,CHARINDEX('\',SYSTEM_USER)+1,LEN(SYSTEM_USER)-CHARINDEX('\',SYSTEM_USER))
AND Date_Start BETWEEN DATEADD(week, DATEDIFF(week, 0, GETDATE()), 0)
AND DATEADD(week, DATEDIFF(week, 0, GETDATE()) +1, 0) -1
-- My Utilization This Week
SELECT ROUND(ISNULL(SUM(ISNULL(Hours_Actual,0) * ISNULL(Billable_Flag,0)) / SUM(Hours_Actual),0) * 100,0)
FROM v_TimeRecords
WHERE Member_ID = SUBSTRING(SYSTEM_USER,CHARINDEX('\',SYSTEM_USER)+1,LEN(SYSTEM_USER)-CHARINDEX('\',SYSTEM_USER))
AND Date_Start BETWEEN DATEADD(week, DATEDIFF(week, 0, GETDATE()), 0)
AND DATEADD(week, DATEDIFF(week, 0, GETDATE()) +1, 0) –1
-- My Utilization Last 12 Weeks
SELECT DATEPART(ww, Date_Start), ROUND(ISNULL(SUM(ISNULL(Hours_Actual,0) * ISNULL(Billable_Flag,0)) / SUM(Hours_Actual),0) * 100,0)
FROM v_TimeRecords
WHERE Member_ID = SUBSTRING(SYSTEM_USER,CHARINDEX('\',SYSTEM_USER)+1,LEN(SYSTEM_USER)-CHARINDEX('\',SYSTEM_USER))
AND Date_Start BETWEEN DATEADD(week, DATEDIFF(week, 0, GETDATE()) -12, 0)
AND DATEADD(week, DATEDIFF(week, 0, GETDATE()), 0) –1
GROUP BY DATEPART(ww, Date_Start)