Forum Replies Created

Viewing 9 posts - 256 through 264 (of 264 total)

  • RE: Election Day

    Nelson Williams-487553 (11/2/2010)


    By the way, who the friend who is a Senate candidate? Just curious. I am not going to do anything nasty.

    His name's Geoff Cook - I think he's...

  • RE: Election Day

    Nor me. I was surprised to find that one of my old classmates is standing for Senate though, especially as we're from England!

  • RE: Bad SQL Jokes

    Thanks, Ray - that's just what I was after! :smooooth:

  • RE: Where are you?

    Chris Morris-439714 (10/20/2010)


    Good Lord Tom, I'd always crossed Lanzarote right off my potential places to visit list because of the British tourism.

    There's a lot of anti-British propaganda around. Don't...

  • RE: Datetime tricks

    This one's handy for calculating public holidays. I've always had fun with Easter!

    http://www.tek-tips.com/faqs.cfm?fid=5075

  • RE: You'd think I'd have learned...

    Forgetting to use SET when assigning a variable. Why can't it be optional like it was in BASICA? 😉

  • RE: rounding error?

    Could you wrap the function in a ROUND to get back to 300? For example:

    SELECT ROUND( (100 / CAST(a.MonthPop AS decimal(10, 2))) * (CAST(b.MonthPop

    AS decimal(10, 2)) -...

  • RE: Output of Query

    Hugo Kornelis (10/28/2010)


    I must say that I am also very surprised (and disappointed) by the amount of incorrect answers. Almost 25% of respondents expect NULL to be returned as well...

  • RE: dynamic column headings and rolling 3 months

    Things will start to get a lot simpler if you can use the modulo operator. For example, (@CurrentMonth + 3) % 12 will automatically return 1 if @CurrentMonth is 10....

Viewing 9 posts - 256 through 264 (of 264 total)