How can we help you today? How can we help you today?

Incorrect usage of UDF IsDescendantOf

DECLARE @Parent HIERARCHYID = '/'

SELECT *
FROM Customers_Hierarchy
WHERE CustomerHierarchy.IsDescendantOf(@Parent) = 1

Hi,

I'm trying to understand the SQL Prompt warning which says this is an incorrect usage of const UDF.
Andy_H
0

Comments

2 comments

Sort by
  • DanC
    Hi @Andy_H thank you for providing the level of detail here! made it very easy to determine this is an issue and witness it myself. I'm going to escalate this to the developers and I'll give you an update once I have some info! 
    DanC
    0
  • DanC
    Hi @Andy_H this has now been fixed and released in Prompt 10.1.0, so if you could please upgrade to the current latest!
    DanC
    0

Add comment

Please sign in to leave a comment.