By Emma Tsai
Performing functional testing for software applications is part of the job as a business analyst. Occasionally, I need to work with SQL server to do database queries so that I can verify that the application pulls data results as expected. Recently, I learned how to use PIVOT operator to group and aggregate data in SQL database. Here is how it works:
In pivot queries, here are the thr...

by Kristi Feng
Last week, I came across a discussion in the Sage 300 ERP VBA forum with a very interesting view of CS0120.

When creating customization projects, I often find the need to search for a field in a record that is not originally part of the index key or requires me to use a complex SQL query statement.  

While I usually retrieve data by connecting to the database using MS ADO, I...