Are you using any BI tool? Discoverer or OBIEE?<br><br><div class="gmail_quote">On Mon, Nov 5, 2012 at 10:36 AM, julianne anyim <span dir="ltr">&lt;<a href="mailto:julianneanyim@gmail.com" target="_blank">julianneanyim@gmail.com</a>&gt;</span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hello,<br><br>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.<br>
<br>Anyone with the syntax please?<br><br>Regards,<br>Julianne<br>
<br>_______________________________________________<br>
Skunkworks mailing list<br>
<a href="mailto:Skunkworks@lists.my.co.ke">Skunkworks@lists.my.co.ke</a><br>
------------<br>
List info, subscribe/unsubscribe<br>
<a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks</a><br>
------------<br>
<br>
Skunkworks Rules<br>
<a href="http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94" target="_blank">http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94</a><br>
------------<br>
Other services @ <a href="http://my.co.ke" target="_blank">http://my.co.ke</a><br></blockquote></div><br>