Community

Manipulate a SQL recordset row with ROW_NUMBER,CTE and CASE

(Jack Vamvas) Question: How can I write a query to return a recordset and do something to a specific row? I understand this is a presentation issue – because the obvious answer is to return the recordset and then do some manipulation at the presentation layer, but the current situation requires me o