title: i am getting Msg 512, Level 16, State 1, Line 1
body: <p>i am getting msg 512 in SQL. what i am trying is to display employee name from I_HR_EMPLOYEE_MASTER.  </p>
  
  <pre><code>SELECT  A.MONTH,(SELECT SUM(AMOUNT) FROM V_HR_PP_PROCESS_DATA 
  WHERE EMPLOYER_CODE = A.EMPLOYER_CODE AND TAX_YEAR = A.TAX_YEAR AND 
  PROCESS_MONTH = A.MONTH AND EMPLOYEE_ID IN 
  (SELECT EMPLOYEE_ID FROM I_HR_EMP_EMPLOYMENT_DTL 
  WHERE EMPLOYER_CODE = A.EMPLOYER_CODE AND CONTRACT_TERM = 'P') AND 
  PROCESS_MONTH BETWEEN 1 AND 10 AND PD_CODE = 'Z500') AS GROSS_PERMANENT,
  (SELECT EMPLOYEE_NAME FROM I_HR_EMPLOYEE_MASTER),
  (SELECT SUM(AMOUNT) FROM V_HR_PP_PROCESS_DATA WHERE EMPLOYER_CODE = A.EMPLOYER_CODE 
  AND TAX_YEAR = A.TAX_YEAR AND PROCESS_MONTH = A.MONTH AND EMPLOYEE_ID IN
  (SELECT EMPLOYEE_ID FROM I_HR_EMP_EMPLOYMENT_DTL WHERE EMPLOYER_CODE = A.EMPLOYER_CODE 
  AND CONTRACT_TERM = 'F') AND PROCESS_MONTH BETWEEN  1 AND 10 AND PD_CODE = 'Z500') 
  AS GROSS_CASUAL  FROM I_HR_SYS_DATE_MONTHLY A WHERE A.EMPLOYER_CODE = 'RAD' AND 
  A.TAX_YEAR = 2014
  </code></pre>