Timeline for Query to normalize table/combine row text
Current License: CC BY-SA 3.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 21, 2011 at 23:49 | comment | added | Adam | Yea, looks like that's what Thx did in his/her version (as noted, using MSSQL2005). For whatever reason they seemed to work quite a bit faster than manual cursor-ing. Someday I'll probably go back and see if it's actually making less sub queries or what. | |
| Apr 21, 2011 at 21:10 | comment | added | mrdenny | With newer versions of SQL Server CTEs can be used to make this a lot easier. Without knowing the version number row by row processing in a cursor would be needed. A CTE will be doing something very similar under the covers. | |
| Apr 15, 2011 at 16:57 | comment | added | Adam | Are you sure it requires row by row? I came across this page: projectdmx.com/tsql/rowconcatenate.aspx where there are solutions for a simpler cases (where the primary key is not composite). Why is it required in this case? | |
| Apr 15, 2011 at 1:24 | history | answered | mrdenny | CC BY-SA 3.0 |