Skip to main content
Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.


Member since Dec 11, 2008

Recent Blog Comments By David

  • SQL COALESCE() Very Cool, But Slower Than ISNULL()

    Posted on Dec 19, 2006 at 5:10 PM

    Coalesce is much more useful for something like this DECLARE @CodeList varchar(1000) SELECT @CodeList = COALESCE(@CodeList +', ', '') + CAST(EmpCode AS varchar(20)) FROM Employees SELECT @CodeList Where EmpCode is a column in the Employees table, this will return a comma-delimited list of t... read more »