There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.
SELECT acctID, SUBSTRING(
CASE WHEN doc1 = 0 THEN '' ELSE ', doc1' END +
CASE WHEN doc2 = 0 THEN '' ELSE ', doc2' END +
CASE WHEN doc3 = 0 THEN '' ELSE ', doc3' END, 3, 100) AS Docs
FROM SomeTable
To create a new table...
SELECT acctID, SUBSTRING(
CASE WHEN doc1 = 0 THEN '' ELSE ', doc1' END +
CASE WHEN doc2 = 0 THEN '' ELSE ', doc2' END +
CASE WHEN doc3 = 0 THEN '' ELSE ', doc3' END, 3, 100) AS Docs
INTO NewTableName
FROM SomeTable