Skip to main content
Ben Nadel at RIA Unleashed (Nov. 2010) with: Yuk Miu
Ben Nadel at RIA Unleashed (Nov. 2010) with: Yuk Miu

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 »