How do I make a static PDT?

0 0 109

Knowledge Drop

Last tested; Jul 6, 2017

This is not recommended - if you have static values, they should be a non-persisted derived table or written to your database.

That said, you can use sql_trigger_value: SELECT 1 ;;. This value will never change so the PDT will never be rebuilt unless the SQL is changed or someone requests a manual rebuild.

This content is subject to limited support.