Timeline for xkcd-Style Page Numbering

8 events

when toggle format	what	by	license	comment
Jun 17, 2020 at 9:04	history	edited	Community Bot		Commonmark migration
Jun 15, 2015 at 15:32	history	edited	PenutReaper	CC BY-SA 3.0	Altered Code to save bytes, new code correct for all values.
Jun 15, 2015 at 15:18	comment	added	PenutReaper		@MichaelB ah. `CONCAT`, I'm on 2008. So I can't test it without using an SQL fiddle right now. Good call though.
Jun 15, 2015 at 15:14	comment	added	Michael B		doesn't actually help. However, you can rewrite the part after the CTE into:: `select @t=concat(@t,@/i)` that should be smaller. Requires sql2012 though.
Jun 15, 2015 at 15:08	comment	added	PenutReaper		@MichaelB Oh, I thought that I had used `@`, silly me. The `CHAR(8000)` advice is pretty good, I'll try that. I always seem to forget about the existence of `STR()` thanks for the heads up.
Jun 15, 2015 at 14:49	comment	added	Michael B		Remember `@` is a valid identifier in sql and you most likely can get away with `Char(8000)` which is still cheaper than nvarchar(max). You can also convert to `char` instead of `varchar`, or use the `str` function.
Jun 15, 2015 at 10:32	history	edited	PenutReaper	CC BY-SA 3.0	Removed redudant bigint casts and altered where clause to save 32 bytes
Jun 12, 2015 at 16:24	history	answered	PenutReaper	CC BY-SA 3.0