If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Dynamic column in tabular sql

Started by mrcool, 03 May 2006 08:23:37 AM

Previous topic - Next topic

mrcool

Hi frnds,

               I want to get column name dynamically from prompt in tabular SQL. Is it possible?


select distinct /*+ FIRST_ROWS */ e.empdate from emp e where #prompt('cond')# between to_date(#prompt('stdate')#,'DD-MM-YYYY') AND to_date('29-OCT-2005','DD-MM-YYYY')

     In place of #prompt('cond')# i will give the column name.Its working fine in oracle but not working in tabular SQL. Try to help me. Thanks in advance

Mrcool