Return to Answer

Commonmark migration

Source Link

edited Jun 17, 2020 at 9:04

#T-SQL, 133 bytes

T-SQL, 133 bytes

Added some line changes to make it readable

SELECT
SUM(iif('P'=type,nullif(substring(
translate(@,'AVNZMWCUSO','4455662210'),
number,1),substring(@,number,1))-3,0))
FROM spt_values

#T-SQL, 133 bytes

Added some line changes to make it readable

SELECT
SUM(iif('P'=type,nullif(substring(
translate(@,'AVNZMWCUSO','4455662210'),
number,1),substring(@,number,1))-3,0))
FROM spt_values

Added some line changes to make it readable

SELECT
SUM(iif('P'=type,nullif(substring(
translate(@,'AVNZMWCUSO','4455662210'),
number,1),substring(@,number,1))-3,0))
FROM spt_values

Source Link

created Jun 3, 2020 at 13:02

#T-SQL, 133 bytes

Added some line changes to make it readable

SELECT
SUM(iif('P'=type,nullif(substring(
translate(@,'AVNZMWCUSO','4455662210'),
number,1),substring(@,number,1))-3,0))
FROM spt_values