The Table Structure:

CREATE TABLE [dbo].[RuleHierTest]

(

[gPK] [uniqueidentifier] ROWGUIDCOL NOT NULL,

[grObjType] [uniqueidentifier] NOT NULL,

[hHierId] [hierarchyid] NOT NULL,

[szID] [nvarchar](32),

[szDescription] [nvarchar](128),

[nHierIdLevel] AS ([hHierID].[GetLevel]())

)

Query input parameters:

gPK='35D39394-65AC-E211-A408-005056C00008' -- = hHierID '/3/32/4/'

grObjType = 'D370B2C5-8CEB-4C94-B0C5-9C0F62387CC5'

This code...

Thanks for the suggestion. I tried it and noticed that the name of the function in the Lib database had been changed, so I fixed the name in the...

Very helpful article. I now have my databases all set for ANSI compliance. The only issue that I have is that the system stored procedures are not ANSI...