Incorrect usage of UDF IsDescendantOf

Andy_H

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.

As far as I can see, this is the correct way to use IsDescendantOf
https://docs.microsoft.com/en-us/sql/t-sql/data-types/isdescendantof-database-engine?redirectedfrom=MSDN&view=sql-server-ver15

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

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!