Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
I am the chief technical officer at InVision App, Inc - a prototyping and collaboration platform for designers, built by designers. I also rock out in JavaScript and ColdFusion 24x7.
Meanwhile on Twitter
Loading latest tweet...
Ben Nadel at cf.Objective() 2014 (Bloomington, MN) with:

Jason Rushton

Member since Dec 11, 2008

Recent Blog Comments By Jason Rushton

  • Selecting Top X From Each Group

    Posted on Jan 7, 2008 at 4:49 PM

    Maybe I'm overlooking something, but wouldn't this query do what you're looking for? SELECT * FROM @girl g1 WHERE id IN ( SELECT TOP(3) id FROM @girl g2 WHERE g1.hair = g2.hair ORDER BY Score DESC ) ORDER BY Hair, Score DESC... read more »

  • Getting @@RowCount After SQL INSERT INTO Statement

    Posted on Nov 28, 2007 at 5:39 PM

    Triggers are the big thing that can give you problems. If your insert initiated a trigger which did it's own insert, using @@IDENTITY would give you the identity for the triggers insert. Scope_Identity() would give you the identity you were probably expecting.... read more »

  • Getting @@RowCount After SQL INSERT INTO Statement

    Posted on Nov 28, 2007 at 5:02 PM

    Christoph: Just a note, but you should really use SCOPE_IDENTITY() rather than @@IDENTITY, because you can run into conditions where you get an ID you're not expecting otherwise.... read more »

  • Regular Expressions Make CSV Parsing In ColdFusion So Much Easier (And Faster)

    Posted on Sep 28, 2007 at 10:57 AM

    Here, we use the java Ostermiller CSV parser http://ostermiller.org/utils/CSV.html On my test server, your code running at around 4000 - 5000ms Ostermiller's is under 300ms We do A LOT of data importing and exporting, so I've spent tons and tons of time looking for the best way to parse files. ... read more »

  • Getting Only The Date Part Of A Date/Time Stamp in SQL Server (Revisited)

    Posted on Sep 21, 2007 at 11:47 AM

    We do have a function for doing this. However, from just testing it in a group by for the year, involving around 300,000 records, the inline version is about 4x faster. We use the function for param sets, and in the select clause, but if we're at all concerned about speed, we avoid functions if at... read more »

  • Getting Only The Date Part Of A Date/Time Stamp in SQL Server (Revisited)

    Posted on Sep 21, 2007 at 11:09 AM

    We use the convert Char(10) method here too. CONVERT( DateTime, CONVERT( Char(10), ci_importDate, 101 ) ) I benchmarked the different methods in our database hoping yours might be faster, because we use it for date grouping A LOT for our in house reporting. Every thing I run shows the two you post... read more »