Timeline for answer to Find the column given a data-value in SQL by DanOrc
Current License: CC BY-SA 4.0
Post Revisions
11 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| 21 hours ago | comment | added | kesarling | @MatBailie It simplifies in the sense that I do not need to type 68 column names and 67 ORs manually. I see that as a win. | |
| yesterday | comment | added | MatBailie | @kesarling Not sure how how this simplifies or generalises your query. | |
| 2 days ago | comment | added | kesarling | @MatBailie lol, I did! (Just not in those words) :D | |
| Apr 28 at 14:57 | comment | added | MatBailie | @kesarling If all you wanted was a way to generate the column list as text, there are many ways to do that, and you should have said in the question :) | |
| S Apr 27 at 20:50 | review | First answers | |||
| Apr 27 at 21:50 | |||||
| S Apr 27 at 20:50 | history | edited | Dale K | CC BY-SA 4.0 |
edited body
|
| Apr 27 at 18:22 | history | edited | takendarkk | CC BY-SA 4.0 |
deleted 12 characters in body
|
| Apr 27 at 18:16 | vote | accept | kesarling | ||
| Apr 27 at 18:12 | comment | added | kesarling |
So the snowflake equivalents seem to be || for + and LISTAGG for STRING_AGG but apart from that, I think this is what I wanted. Let me see.
|
|
| S Apr 27 at 18:04 | review | First answers | |||
| Apr 27 at 18:48 | |||||
| S Apr 27 at 18:04 | history | answered | DanOrc | CC BY-SA 4.0 |