Rick Pack
- Total activity 10
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 5
- Subscriptions 2
Activity overview
Latest activity by Rick Pack-
Rick Pack created a post,
BIGDECIMAL still needed for comparisons? Errors in SQL Worksheet
AnsweredDo we still need to use BIGDECIMAL on numeric variables, at least sometimes, in order to perform comparisons against some numbers, possibly only those with a decimal like 6.4? We encountered this n...
-
Rick Pack commented,
Here was the solution. I appear to have been hitting a reserved keyword problem and / or needed the YEAR function in the GROUP BY clause, per Stack Overflow responder, Tim Biegeleisen. SELECT YEAR(...
-
Rick Pack created a post,
Error in using YEAR function in SQL Worksheet
AnsweredIn Datameer, how do you capture the year of a DATE column in a SQL worksheet? This query SELECT YEAR(rslt_part.draw_date) AS YEAR, COUNT(*) AS CT FROM rslt_part GROUP BY YEAR is returning the foll...