Project Log

Every project in order, from my first CSS card to client-ready work.

Done
In progress
Planned

Loading projects…

Under the hood

These cards are stored in SQL Server and loaded with JavaScript. The page calls this stored procedure:

SELECT p.Title, p.Description, p.Status, p.CompletedOn,
       STRING_AGG(t.Name, ',') AS Tags
FROM dbo.Projects p
LEFT JOIN dbo.ProjectTags pt ON pt.ProjectId = p.ProjectId
LEFT JOIN dbo.Tags t ON t.TagId = pt.TagId
GROUP BY p.ProjectId, p.Stage, p.Title, p.Description,
         p.Status, p.CompletedOn
ORDER BY p.Stage, p.CompletedOn;