A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
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.
|How to handle time out inside the stored procedure||10||27|
|compare date to getdate()||8||18|
|SQl query with join with out having to list all fields in main table.||2||16|
|SQL Query that uses count(*) over, possible to use distinct?||18||49|