CREATE  PROCEDURE dbo.GetSchedule(
     @UserID  INT
)  
  AS
  
  SELECT [EmpName], [Date], StartTime, EndTime, StartBreakTime, EndBreakTime, Notes
  INTO #TempTable
  FROM Schedule  WHERE SupervisorID=@UserID AND DATEDIFF(DAY,  GETDATE(), [Date])>-1
  
  DECLARE @MyFields  NVARCHAR(300)
  
  IF EXISTS(SELECT ScheduleFields  FROM UserPrefs  WHERE UserID=@UserID)
      BEGIN
      SELECT TOP 1 @MyFields=ScheduleFields  FROM UserPrefs  WHERE UserID=@UserID
      END
  ELSE
      BEGIN
     SET @MyFields = '*'
      END
  
  
  DECLARE @SQL  NVARCHAR(1000)
  
SET @SQL= 'SET ANSI_WARNINGS OFF;SELECT '+ @MyFields + ' FROM #TempTable;SET ANSI_WARNINGS ON;'
  
EXECUTE sp_executesql @SQL