Answer: SQL server: How can I convert dates to base 36 annexed (3-digit)?

answer re: SQL server: How can I convert dates to base 36 annexed (3-digit)?

Jul 1 '20

0

enter image description here

Tq @Fandango's answer, manage to get 00U at the 31th row using the code below:

WITH
  num AS (SELECT TOP 36 ROW_NUMBER() OVER(ORDER BY (SELECT 1)) i FROM rt_packing)
  chr AS (SELECT i,CASE WHEN i <= 10 THEN CHAR(i+47) ELSE CHAR (i+54) END c FROM num)

…

Open Full Answer