on 08-17-2016 10:24 PM
Hi all,
Is it possible to create "dynamic" SQL statements with Parameters?
For example, I created a parameter called "CUSTOM_PARAM".
I set it to something like "(CASE WHEN COMPANY_ID > 100 THEN 1 ELSE 0 END) AS CUST_ATTR".
I then created a Derived Table:
SELECT
a.*,
@Prompt(CUSTOM_PARAM)
FROM company_table a
Unfortunately when I show values, the CUSTOM_PARAM is showing up as a string.
Any idea how I can make my SQL script or Derived Table dynamic?
what is the data type of parameter you have selected in the Parameters and list of values section in data foundation?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.