Forum Replies Created

Viewing 15 posts - 481 through 495 (of 584 total)

  • RE: Select top row and second top row from DIM table

    Cadavre (9/26/2011)[hr

    Good morning and welcome to SSC!

    It seems that your DDL script seems to have become detached from your post, or perhaps you were unaware of the benefits of...

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

  • RE: Use of BETWEEN and DATETIME

    I was originally going to post something saying that the question, which I got right, was needlessly tricky. However, on further reflection, I thought it was perfectly fair. How many...

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

  • RE: Power of implicit conversion

    Excellent! Just the right amount of grey cell stimulation for an early Monday morning. Thanks.

    Great example of taking two simple things you "know" (precedence and conversion) and synthesizing them into...

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

  • RE: Big Gaps

    Two things missing:

    1. Willingness to LISTEN to customer requirements - not give them what you think they need

    2. Willingness to spend a little extra time to come up with a...

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

  • RE: Union results

    Nice example of the question not being more complicated than necessary to demonstrate the point. Thanks for the question.

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

  • RE: Table Access Order

    Not only a great question, but a superb explanation. Thanks.

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

  • RE: SubQuery

    Thanks. Got it right - but almost went for the first instance of the name change. Good thing I kept "parsing". Thanks for the lesson!

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

  • RE: Unary & Aliases

    Nice question Carlo! My first thought was, "What am I supposed to learn from this question?" Then I dug in a little deeper. Got it right, but not as quickly...

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

  • RE: Database Collation

    Tom.Thomson (9/12/2011)


    Thomas Abraham (9/12/2011)


    "Always" is what did it for me too - what about not having permission to read from that table?

    Can't happen - you always have permission to read...

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

  • RE: Database Collation

    cengland0 (9/12/2011)


    I got it right but for the wrong reason. The reason specified was for case sensitivity but I thought of other reasons it wouldn't run. The question...

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

  • RE: Database Collation

    paul s-306273 (9/12/2011)


    Thomas Abraham (9/12/2011)


    BTW, can anyone else see a question for October 14, 2011 in their list of "previous" questions?

    Yes - I can see it too!

    If he's going to...

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

  • RE: Database Collation

    Thanks for the question.

    BTW, can anyone else see a question for October 14, 2011 in their list of "previous" questions?

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

  • RE: Order By Clause

    Thanks for a good question. Missed the subquery ORDER BY clause error as I never use ORDER BY in a subquery - expect all results before my final output will...

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

  • RE: Odd men out

    Feel a bit deflated at having my streak of correct answers ended by a question like this. Luminaries?

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

  • RE: Resource Governor

    Almost missed it, using "Features Supported by the Editions of SQL Server 2008" as a reference, since it only mentions Enterprise. Good thing I paused to reflect this morning. Thanks...

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

Viewing 15 posts - 481 through 495 (of 584 total)