Timeline for Is it possible to change recursion level of a CTE in a function?
Current License: CC BY-SA 3.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 13, 2016 at 3:40 | history | edited | Paul White♦ |
edited tags
|
|
| May 15, 2015 at 16:19 | vote | accept | Eric S | ||
| May 15, 2015 at 12:34 | answer | added | Mister Magoo | timeline score: 2 | |
| May 12, 2015 at 18:36 | comment | added | Eric S | The original reason for this function was to solve part of a bigger problem where I have to split values in a column so I can join the results on to another table (Think of unpivoting a column essentially). Example: a column contains the value "4213" which represents that the row first relates to the 4th attribute, then the 2nd attribute, then the first attribute etc. So I would then use this information to join to the attribute table. If this sounds confusing, or really dumb, that is because it is. But that is what the original design was for the tables so I am trying to work around it. | |
| May 12, 2015 at 18:29 | answer | added | Eric S | timeline score: 1 | |
| May 11, 2015 at 20:15 | comment | added | Mikael Eriksson | How about using a different approach to splitt the string in the function? If you use a numbers table instead you don't need the recursion and it will faster. | |
| May 11, 2015 at 20:11 | answer | added | RLF | timeline score: 0 | |
| May 11, 2015 at 19:59 | history | asked | Eric S | CC BY-SA 3.0 |