spGetUserOverriddenPrivacyFields

          CREATE PROCEDURE [dbo].[spGetUserOverriddenPrivacyFields] (
          @SearchFieldList nvarchar(500),
          @AttributeList nvarchar(500)
          )
          AS
          SET NOCOUNT ON

          SELECT BSP.BackofficeRecordID, CUFP.FieldID, CUFP.FieldAttribID, CUFP.Private FROM
          BackOfficeSystemPeople BSP
          INNER JOIN ClientUserFieldPrivacy CUFP ON BSP.ID = CUFP.BackofficeSystemPeopleID
          INNER JOIN ApplicationFields AF ON (AF.PrivateShowByDefault = CUFP.private OR AF.PrivateShowByDefault = 0) AND AF.FieldID = CUFP.FieldID AND CUFP.FieldAttribID = AF.AttribTypeID
          INNER JOIN fnCSVIDsToTable(@SearchFieldList) SC ON SC.id = CUFP.FieldID
          INNER JOIN fnCSVIDsToTable(@AttributeList) AL ON AL.id = CUFP.FieldAttribID