Forum Replies Created

Viewing 15 posts - 2,881 through 2,895 (of 7,484 total)

  • RE: Wildcards

    Steve Jones - SSC Editor (11/22/2013)

    Tom,

    You're being pedantic here in terms of the question. The question isn't which of these are single characters, which which wildcards match.

    Yes, I'm probably being...

    November 23, 2013 at 5:26 pm

    #1668632

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (11/22/2013)

    Lynn Pettis (11/22/2013)

    Well, doing the job search thing is tedious. Thinking about applying for this position but pretty sure I only meet half the requirements. I...

    November 23, 2013 at 4:58 pm

    #1668629

  • RE: Are the posted questions getting worse?

    Ed Wagner (11/22/2013)

    I never had the "pleasure" of working with either of those IBM products, but I've been forced to work with other ones. If they're any judge, it's...

    November 23, 2013 at 4:51 pm

    #1668626

  • RE: Coin combinations

    dwain.c (11/17/2013)

    Tom,

    Interesting problem but I can't quite wrap my head around what you're looking for. But here's an rCTE solution that may be something like it.

    <code omitted>

    This calculates the...

    November 23, 2013 at 1:45 pm

    #1668618

  • RE: Coin combinations

    mister.magoo (11/17/2013)

    I forgot to mention, the WHILE loop / *Identity Hack* version takes about the same time as your sample script for the 57596 result, and about 3 times that...

    November 23, 2013 at 12:24 pm

    #1668612

  • RE: Coin combinations

    mister.magoo (11/17/2013)

    Hi Tom,

    A generic cte is possible, but I want to show you my WHILE loop first because it can handle the data and my CTE can't!

    I'm beginning to think...

    November 23, 2013 at 10:51 am

    #1668607

  • RE: Coin combinations

    LutzM (11/17/2013)

    Isn't that more a scenario for CROSS JOINS rather than a recursive cte?

    Yes, it needs cross joins if conditions that allow you to avod them aren't met. But...

    November 23, 2013 at 8:31 am

    #1668595

  • RE: Wildcards

    Bad question because the words you were wrote don't necessarily mean what you apparently think they do. Or was it intentionally a trick question?

    Mind you, it's not as bad...

    November 22, 2013 at 12:40 pm

    #1668514

  • RE: SSIS Variable Casting

    Valued Jones (11/20/2013)

    This question gave me a headache.. then I went to the reference page and it got worse. Looks like I need to read up on this so I...

    November 22, 2013 at 11:42 am

    #1668497

  • RE: SQL Server 2014 Configuration

    Koen Verbeeck (11/18/2013)

    Please read the entire MSDN page you linked to.

    The following SQL Server Database Engine features are supported in the next version of SQL Server, but will be removed...

    November 22, 2013 at 10:42 am

    #1668485

  • RE: Today's Random Word!

    SQLRNNR (11/21/2013)

    API

    PGU-14/B, or something less warlike?

    November 21, 2013 at 12:27 pm

    #1668224

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (11/18/2013)

    Went over 11,000 points a while back and I also managed to wringle myself into the top 10 (sorry Paul).

    😎 :w00t:

    Congrats.

    When do you plan to catch...

    November 18, 2013 at 10:42 am

    #1667206

  • RE: Select Statement Sum Question

    Jeff Moden (11/16/2013)

    scotsditch (11/16/2013)

    Please let me know if you have any other advice on how I can improve my posts.

    I'd strongly recommend you try to run your code before you...

    November 17, 2013 at 8:58 am

    #1666946

  • RE: 2 records at a time?

    LutzM (11/17/2013)

    Since you already have the BorrowerOrder column I'm not sure why it would need to be so complicated...

    Wouldn't a simple BorrowerOrder < 2 be enough?

    SELECT

    *

    FROM

    #t AS t

    WHERE BorrowerOrder...

    November 17, 2013 at 8:26 am

    #1666943

  • RE: Guidance

    Jeff Moden (11/16/2013)

    There is one variable in the equation where I never say "It Depends" in the guidance I try to offer and that is "Crap Code will cripple your...

    November 16, 2013 at 11:37 am

    #1666900

Viewing 15 posts - 2,881 through 2,895 (of 7,484 total)