• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 313
  • Last Modified:

Column Size limitation when using CTEs

Hi,

  I was using Kent's technique to concatenate row values (below link).

 I have two values, which i have to concatenate. But i get this error.
SQL0433N  Value "RULED OUT,UNSUBSTANTIATED" is too long.  SQLSTATE=22001

Open in new window

Is there a way to use this technique and yet work around this column size issue?
Please help.
0
pvsbandi
Asked:
pvsbandi
  • 2
1 Solution
 
momi_sabagCommented:
could you post the entire query?
0
 
pvsbandiAuthor Commented:
Hi,

 Never mind.. i found the answer in the same article  :)
 I need to cast the concatenating string to a specific length, to avoid the error.
 Thank you much for your attention.
0
 
pvsbandiAuthor Commented:
found it in the article
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now