title: SQL Pivot table larger column value gives too long error
body: <p>I'm writing a dynamic sql pivot table query with a dataset. But when a nvarchar column value is used on the pivot, when the column value is larger than 128 it gives below error</p>
  
  <p>The identifier that starts with &lt;> is too long. Maximum length is 128.</p>
  
  <p>Any workaround which can resolve this?</p>