Are you using any BI tool? Discoverer or OBIEE? On Mon, Nov 5, 2012 at 10:36 AM, julianne anyim <julianneanyim@gmail.com>wrote:

Hello,

I need to create a dynamic cross tab query where columns will not always be fixed in number so cant hard code using CASE WHEN.

Anyone with the syntax please?

Regards, Julianne

_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke