Tabular Report

From: Jill <jc_va_at_hotmail.com>
Date: Tue, 31 Aug 1999 10:15:30 -0700
Message-ID: <7qgo2b$n25$1@bgtnsc02.worldnet.att.net>

Tabular Report

I have a table that has SSN, Week,Type, and Hours. Type is for a pay type such as Regular, Sick, Vacation, etc. I would like to have an SQL query produce a report in a tabular format as such:

SSN               DATE  REG  SICK etc.
xxx-xx-xxxx   8/29/99   32           8  etc.

The universe of earnings types is finite and is about 8. Other than having a view made up of UNION ALL statements, is there another way to do this? Received on Tue Aug 31 1999 - 12:15:30 CDT