spGetProfileEditFields

        CREATE    PROCEDURE [dbo].[spGetProfileEditFields]
                (
                    @ContentID int,
                    @fieldType int,
                    @clientsId int
                )
            AS

                SELECT     vw.fieldid, vw.AttribTypeID, vw.category, vw.Category + '.' + vw.fieldName as FullName, vw.fieldname, vw.sequence, vw.fieldtype, vw.parentFieldID CategoryId, 
                                      fn.Caption, fn.Editable, fn.Required, fn.AllowDelete, 
                                      fn.AllowPrivate, fn.UseCodeTable, fn.AllowNewCodes, fn.ContentID, 
                                      fn.ID, fn.Include, vw.AttribTypeID, fn.ShowInGrid
                FROM         dbo.fnGetClientCategorizedFields(@clientsID) vw LEFT OUTER JOIN
                                      dbo.fnProfileEditorFields(@contentid) fn  ON (vw.FieldID = fn.FieldID and (vw.AttribTypeID = fn.FieldAttribID))
                                      where vw.formfield = 1 and not parentFieldid is null and vw.DataType<>10
                                      order by vw.CategorySequence, vw.sequence