Microsoft / Wikimedia Commons — Public domain
Working notes on MS SQL: Case, Column condition, Datediff as time, Function, Procedure, and Temprorary Tables.
Working notes on MS SQL: Case, Column condition, Datediff as time, Function, Procedure, and Temprorary Tables.
Topics
Case
IS NULL Then "Absent" else "" end as _B_.
Column condition
Case when Z.xDate IS NULL Then "Absent" else "Present" end as _B_.
Datediff as time
CONVERT(varchar(12), DATEADD(ms, DATEDIFF(ms, @dt1, @dt2), 0), 114).
Function
Must be stored in db.
Procedure
Create Procedure @Present (@dateX datetime).
Temprorary Tables
Global.
Updated:
2026 Aug 19
