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]
