Forum Replies Created

Viewing 15 posts - 241 through 255 (of 338 total)

  • RE: Query

    aweican (4/7/2008)


    datename(m,join_date) like '%a%' ???

    Where is the "a" in Feb

    Oh dear! how to miss the point! 😀

    (Hint: it is s the 6th letter of february)

  • RE: Query

    Steady on Tom - what's the point in Tar and Feathering an empty corpse? 🙂

  • RE: Query

    Sorry major - I meant full (insert local language here) spelling of the month, not an abreviation such as FEB; my bad!

    Thanks for pointing that out. 🙂

    How many pages will...

  • RE: Query

    Post multiple times = multiple points :w00t:

    (damn you brain - stop giving away the secrets)

    --Shaun

  • RE: Query

    Doh! datename - look up the function dude!

    takes the raw data and uses the full string of the name so when your field has a datetime type

    datename(m, datetime_field) gives the...

  • RE: Query

    And so it continues.... 😉

    Tell us another joke major. 😀

    --Shaun

  • RE: Largest Unit

    Steve:

    Definition of EB -

    EB - Europa Barbarorum - excellent historically accurate mod for SEGA/The Creative Assembly's most awsome game Rome Total War. 😀

  • RE: Largest Unit

    Aleksandr Furman:

    How is that funny?

    Is that not the truth? 😉

    Like the one told to me by an accountant;

    "There are three types of accountant in this world, those who can...

  • RE: Largest Unit

    Education is the goal, entertainment is the medium 😀

    --Shaun

  • RE: Largest Unit

    Hugo:

    That is exactly why I've invented the ShaunyByte!:D

    A single BS is all you need, no matter how much data you have.

    the expanding BS is given an order to denote how...

  • RE: Largest Unit

    Total Bull!

    1024^8 != 10^24

    1000^8 != 2^80

    Store everything in the universe? Doubting Dog says - 'I doubt it!':P

    Hey I've invented the 'ShaunyByte' its 2^(80 + an number incrementing as required) and...

  • RE: ORDER BY

    Gene none of the anwers mentions a repeated column name.

    Please I'm tired of this debate. 😉

    --Shaun (who I am not Sean)

  • RE: ORDER BY

    Ravi

    oh dear!

    'perfectly' ...er try again please!

    your results do not fit any of the possible answers.:)

    please read the preceeding 10 pages to learn why:P

    --Shaun

  • RE: ORDER BY

    For the last time, yeah right!:)

    SQL2000/SQL2005(Mode 80) do not 'fail/give an error response', but give a result which matches none of the answers to the question.

    Therefore they are not applicable....

  • RE: Training Programmers: Accessing Base Tables or Stored Procs

    Loner - RBAR - see Jeff's signature 🙂

    All about evil cursors/triangular joins etc. in SQL

Viewing 15 posts - 241 through 255 (of 338 total)