I specialize in support and customization for Counterpoint SQL. This is a Point of Sale and Order Entry software for Hard goods and Soft goods retailers and/or distributors. I was on the design team for Counterpoint SQL since its inception in the early 2000s. Then I worked for one of the Sales Partners for several years before starting my own company -- POS-Abilities.
Most of my customizations involve changes to existing reports or development of new reports using Crystal Reports (V10 or XI). This often requires changes to the MS-SQL Database - New columns, tables, or views or development of stored procedures to deliver data to the report.
I'm also called upon to add columns to the database for tracking additional information or to introduce SPs that change the behavior of the software.
In the past, I've gotten many answers to SQL questions from StackOverflow so I decided it was time to actually join the community.