Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
Currently, scalar UDF containing non-deterministic functions (such as GETDATE) can't be used in combination in a query with a user table.
e.g. create dbo.udf () returns datetime2 as begin return getdate() end
this query would fail:
select col1, dbo.udf() as udf_output
from usertable1
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.