title: Update statement is not working
body: <p>Can any one suggest the reason why update statement is not working in SQL-SERVER-2008 for the code mentioned below</p>
  
  <pre><code>UPDATE [dbo].[CTRL_SECURITY]
  SET BI_FIN_FLG = ISNULL(CAF.BI_FIN_FLG,'N'), 
             BI_HR_FLG = ISNULL(CAF.BI_HR_FLG,'N')
  FROM dbo.CTRL_APP_FLG AS CAF
  LEFT JOIN [dbo].[CTRL_SECURITY] AS CS
        ON CAF.TABLE_COLUMN_VALUE = CAST(CS.ACCOUNT_ID AS VARCHAR(180))
     WHERE ACCOUNT_ID IN(SELECT TABLE_COLUMN_VALUE FROM dbo.CTRL_APP_FLG WHERE TABLE_NAME='DIM_ACCOUNT')
  </code></pre>