fnGetAttributeAppParentChildMap

CREATE FUNCTION [dbo].fnGetAttributeAppParentChildMap()

RETURNS @ObjectMap TABLE (
fieldid int, 
parentfieldid int
)

AS
BEGIN
    INSERT INTO @ObjectMap 
    select fieldid, parentfieldid from applicationfields where not parentfieldId is  null
    order by parentfieldID, fieldid
    RETURN
END