Hi Dev,

I checked by removing "NOLOCK". error still there. issue seems to be somewhere else.

Thanks

Harish

Thanks.

exec RetrievingNode @Keys='one,two,three'

This stored proc takes a key path and returns node as well its children.

here are the database table

CREATE TABLE [dbo].[KeyedNodes](

[Id] [int] IDENTITY(1,1) NOT...