Sigh.....can you not use a CTE in a SQL script for SmartList Builder?
The CTE works, when I run it in SQL. But, when I copy the script into SmartList Builder, it's giving me a message saying that the "SQL script is invalid".
I really don't want to have to create a view. The CTE is pretty simple and convenient.
Thanks!
John
*This post is locked for comments
I solved this by modifying my CTE to be a "regular" select statement.
So, I'm all set.
Thanks!
John
Hi Mike:
That's true. And, I have done so, before.
But, there's some "red tape" that I have to go through in order to place views in production. I was hoping that SLB could simply use a CTE script, just as it can use a "select" script.
I didn't want to have to go through "protocol" with a separate department. :)
Thanks!
John
John, Why not create a view using your CTE statement?
Then you can add the view to Smartlist Designer or Smartlist Builder
Don't forget to run Grant.sql and then also (if using smartlist builder) grant access to the view through the smartlist builder interface. (you have to explicitly check the tables and views that you want to include in Smartlist Builder)
Share
Report
All responses (
Answers (
1,484
