Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at dev.Objective() 2015 (Bloomington, MN) with: Justine Arreche
Ben Nadel at dev.Objective() 2015 (Bloomington, MN) with: Justine Arreche@saltinejustine )

David

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 »