Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement. It’s sometimes difficult to know which SQL syntax to use when ...

A common SQL habit is to use SELECT * on a query, because it’s tedious to list all the columns you need. Plus, sometimes those columns may change over time, so why not just do things the easy way? But ...

The DICTIONARY tables component is specified in the FROM clause of a SELECT statement. DICTIONARY is a reserved libref for use only in PROC SQL. Data from DICTIONARY tables are generated at run time.

You poured data into a pivot table. Now what? Make them smarter. Here's how to use Summarizing Data and Calculated Fields in order to get a different perspective on your marketing data through the ...

Ok, I'm doing this web page stuff for someone. They want some HTML based 'reports' to be stored in a text field and used in a scripted fashion for viewing the reports. I.E.-They select a report and a ...

Ok. I have some tables that store dollar amounts, among other data. I had the fields set to be a data type of money, and was planning on the values including zero. When selecting the data, I was ...

Jeff continues his exploration of the TfsWorkItemTracking database by showing you how to retrieve a record from a given point in time using some helpful SQL statements. In the first installment of ...