Timeline for It was just a bug
Current License: CC BY-SA 3.0
10 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 17, 2020 at 9:04 | history | edited | Community Bot |
Commonmark migration
|
|
| Jul 4, 2017 at 15:47 | history | edited | Reversed Engineer | CC BY-SA 3.0 |
Improved code as per "Updates"in the text
|
| Jul 4, 2017 at 15:35 | history | edited | Reversed Engineer | CC BY-SA 3.0 |
Use PRINT to obey the rules (no "stringlist" outputs)
|
| Jul 4, 2017 at 15:27 | history | edited | Reversed Engineer | CC BY-SA 3.0 |
Used master..spt_values table to generate numbers
|
| Jul 4, 2017 at 8:02 | comment | added | Reversed Engineer | Aha @ZLK - a few nice tricks - TOP 17, RANK OVER, and sys.objects - thank you! | |
| Jul 4, 2017 at 1:12 | comment | added | ZLK |
A mix between this answer and the other is optimal: e.g. SELECT TOP 17REPLACE('1x2x3x4x5x6x7x8x9x0','x',SPACE(ABS(9-RANK()OVER(ORDER BY object_id))))FROM sys.objects (assuming you don't need to print).
|
|
| Jul 3, 2017 at 19:22 | comment | added | Reversed Engineer | Thanks. I see some of us have invented our own languages here :) | |
| Jul 3, 2017 at 18:59 | comment | added | DJMcMayhem | This is a nice answer! Welcome to the site :) | |
| Jul 3, 2017 at 18:59 | review | First posts | |||
| Jul 3, 2017 at 18:59 | |||||
| Jul 3, 2017 at 18:54 | history | answered | Reversed Engineer | CC BY-SA 3.0 |