Creating Groupings Based on Unique Combinations of MEM_ID, PROV, and ADM_DT in SQL

Adding a Date Column to a Temporary Table in Netezza: A Solution for Common Pitfalls