All Tags » sql » cte (RSS)

Browse Blog Posts by Tags

Showing related tags and posts for the Blogs application. See all tags in the site

  • Set-based approach to finding consecutive records

    I'm sure I've written about this before, but it comes up so regularly in the newsgroups that I thought I'd write an answer here. A table (probably an audit table) exists with a field that stores a date signifying when a change was made. You need to return a result-set which has a row for each period...
    Posted to Rob Farley by Rob Farley on Tue, Jan 16 2007
    Filed under: Filed under: ,

  • Faster binary converter - where do your solutions come from?

    Mitch Wheat is a great guy. He really is. And he's clearly a mathematician. I mean, I did a half-major as part of my BSc, doing a handful of 3rd year Pure Maths subjects (which I got HDs in too - I wasn't just sleeping during class), but Mitch... he thinks like a mathematician. You can tell when...
    Posted to Rob Farley by Rob Farley on Mon, Oct 23 2006
    Filed under: Filed under: , ,

  • Simple recursive CTE

    I like CTEs . Mostly because it lets me have a derived table that I can refer to multiple times. I don't often use the recursive features of it. But when I do, I repeatedly feel amazed at the power available. Today I had a challenge to produce a nice SQL way of converting integers to binary . So...
    Posted to Rob Farley by Rob Farley on Fri, Oct 20 2006
    Filed under: Filed under: ,
Page 1 of 1 (3 items)