|
Subject:
|
Converting large columns into a single row
|
|
Posted By:
|
rahulpokharna
|
Post Date:
|
1/8/2006 1:35:56 PM
|
I want to convert the columns of varchar(400) into a single row. i tried using coalesce but it doesnt works for large amount of data
can anyone please help me in this.
this is the snapshot of table which i am using:---
D0201 as [Nominee Emp No]
D0202 as [Nominee DU Code]
D0203 as [Nominee Project Code]
D0204 as [Nominee DM Email ID]
D0205 as [Nominee Location]
D0206 as [Nominator Email ID]
D0307 as [Specialized domain competency (eg. RETL, Banking, Insurance)]
D0308 as [Quantify the benefits (for e.g. Due to domain competency the KT was given in a day and this resulted]
D0309 as [Any domain specific certifications]
D0310 as [Paper presentation in domain area ]
D0323 as [K-Shop Material]
the coalesce is able to convert into a single row of length 256 characters max, whereas in my case it will go beyond 2000.
Any pointers will be of great help.
Regards
Rahul Pokharna
|
|
Reply By:
|
jbenson001
|
Reply Date:
|
1/8/2006 11:37:40 PM
|
What is the code you are using? Why not just concatenate into a column or variable of VarChar(8000)?
Jim
|
|
Reply By:
|
rahulpokharna
|
Reply Date:
|
1/9/2006 10:00:19 AM
|
thanks jim for ur reply. the max length for a columns was set to 256 only. i reseted it to 8000 and it is working fine now.
regards
rahul pokharna
|
|
Reply By:
|
jbenson001
|
Reply Date:
|
1/10/2006 1:14:21 AM
|
Glad you got it working
|
