Forum Replies Created

Viewing 15 posts - 31 through 45 (of 702 total)

  • RE: Creating Tables

    Hugo Kornelis (2/11/2013)

    . . . . The option "Only the 1st and 3rd statement will succeed but no rows will be returned", though technically not 100% accurate (as the 4th...

    February 13, 2013 at 5:07 pm

    #1587686

  • RE: Basic Date Function

    Revenant (2/13/2013)

    Michael Riemer (2/13/2013)

    +1 to the above points.

    Great question as far as idea and content goes, but needs clarification as to where you are in the world!!

    +1

    (plus one to this...

    February 13, 2013 at 4:50 pm

    #1587683

  • RE: Basic Date Function

    Koen Verbeeck (2/13/2013)

    This question could've been better if the question asker realized there are more than one countries in the world.

    It looks to me as though a lot of the...

    February 13, 2013 at 10:53 am

    #1587584

  • RE: Are the posted questions getting worse?

    RBarryYoung (2/8/2013)

    Revenant (2/8/2013)

    Lynn, remember the bell curve: in any situation 50 percent of the involved are below the average, and 5 percent are on the tail end. That's how normal...

    February 8, 2013 at 11:36 pm

    #1586203

  • RE: Basic maths - operator precedence

    Hugo Kornelis (2/6/2013)

    Dineshbabu (2/6/2013)

    But you steal some of my time by making me to sit and calculate each and every statement..:-) .

    You could have saved that time. I just checked...

    February 6, 2013 at 11:34 am

    #1585078

  • RE: Type conversions and Nulls

    Olga B (2/5/2013)

    Well, the good news is, I got NULLs down pat. The less good news is, I didn't even stop to think about type precedence.

    Conclusion - time for...

    February 5, 2013 at 7:10 pm

    #1584702

  • RE: Oops! SQL column swap or SQL column clobber?

    Gazareth (2/1/2013)

    Raghavendra Mudugal (2/1/2013)

    Dineshbabu (1/31/2013)

    Actually I'm unable to understand the comments and answers properly. Problem is with the word "CLOBBER".....

    Same here but after checking this http://en.wikipedia.org/wiki/Clobbering, it kind of eased...

    February 1, 2013 at 6:12 pm

    #1583617

  • RE: How can we calculate Age of employee?

    Looks to me as though whenever "today's" date has a month later in the year than the birthday and a day-of-month smaller than the day part of the birthday, the...

    January 26, 2013 at 1:26 pm

    #1581329

  • RE: Are the posted questions getting worse?

    Am waiting with bated breath to see if "Saint" Lynn lives up to his kind and understanding reputation. Someone stumbled on an old QOD thread about calculating a...

    January 24, 2013 at 3:27 pm

    #1580735

  • RE: BIT data type

    Excellent question. I speculate that Output 2 drew the most wrong answers due to its double-negative ("not exists ... is not null").

    January 22, 2013 at 12:18 pm

    #1579785

  • RE: Are the posted questions getting worse?

    SQLRNNR (1/18/2013)

    Lowell (1/18/2013)

    Brandie Tarvin (1/18/2013)

    All we need is an actual Go Faster flag for the database, and everything will be FINE.

    got your fix right here:

    I need one of those

    Funny thing...

    January 18, 2013 at 6:06 pm

    #1578912

  • RE: Precedence in math

    call.copse (1/10/2013)

    While it does appear to just test basic maths, I'd argue that doing an example without brackets is just annoying, and I'd be pretty displeased if debugging someone's SQL...

    January 10, 2013 at 10:06 am

    #1575880

  • RE: Talking baseball

    Craig Biggio belongs.

    He was for his time my favorite non-Giant to watch. A catcher who could run, he made the All-star team at that position in 1991. ...

    January 9, 2013 at 3:03 pm

    #1575471

  • RE: Coalesce and Conversion

    How annoying. You made me think! 😉

    I agree this was an excellent question and explanation. I do see that one minor correction could be needed to...

    January 8, 2013 at 10:32 am

    #1574927

  • RE: Finding New Years Eve

    Or, since Nigel has led us outside the box....

    Select convert(datetime, rtrim(Datepart(year,getdate())-1)+'-12-31')

    Yeah, I cheat by using rtrim() as a quickly coded forced conversion to a string.

    January 4, 2013 at 9:38 am

    #1573827

Viewing 15 posts - 31 through 45 (of 702 total)