Good Afternoon,

I have been checking to see if firebird supports cross tab queries natively the way oracle and access do, but to no avail. In oracle i  can do something like this:

select * from
(select W_CD, w_sta_dt,w_end_dt-w_sta_dt AS DAYS_PASSED
from src_table )
PIVOT
( MAX(DAYS_PASSED) for w_sta_dt in ( '3/1/2009',    '3/2/2009',    '3/3/2009',    '3/4/2009',    '3/5/2009',    '3/6/2009',    '3/7/2009',    '3/8/2009',    '3/9/2009',    '3/10/2009',    '3/11/2009',    '3/12/2009',    '3/13/2009',    '3/14/2009',    '3/15/2009',    '3/16/2009',    '3/17/2009',    '3/18/2009',    '3/19/2009',    '3/20/2009',    '3/21/2009',    '3/22/2009',    '3/23/2009',    '3/24/2009',    '3/25/2009',    '3/26/2009',    '3/27/2009',    '3/28/2009',    '3/29/2009',    '3/30/2009',    '3/31/2009' )
 )
ORDER BY W_CD


Don't know what the syntax in access is, but i know its there. thank you.

Regards

Zafar


[Non-text portions of this message have been removed]