Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!
SELECT WempID, Windicator, Whours, Wdate, CASE WIP.Wbillable WHEN '1' THEN WIP.Whours ELSE 0 END AS 'BillActual' FROM WIP WHERE (Wdate BETWEEN convert(datetime,'07/01/' + (@FiscYear -1),101) AND convert(datetime, '06/30/' + @FiscYear,101)) AND (WempID = @MyID) AND (Windicator <> 'D')
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.