Forum Replies Created

Viewing 15 posts - 2,896 through 2,910 (of 7,484 total)

  • RE: Guidance

    I found that I had to offer guidance quite a lot: that's one of the things that happens when you get to be where the buck stops.

    Mostly though I could...

  • RE: I do not understand nested joins

    Grant Fritchey (11/16/2013)


    You're also missing some JOIN criteria here:

    LEFT OUTER JOIN SALES_TAX RIGHT OUTER JOIN

    No, the nest join is nicely matched up with each join having it's corresponding ON clause.

    The...

  • RE: Today's Random Word!

    Revenant (11/15/2013)


    crookj (11/15/2013)


    Kurt W. Zimmerman (11/15/2013)


    L' Eomot Inversé (11/15/2013)


    Ed Wagner (11/15/2013)


    L' Eomot Inversé (11/14/2013)


    Ed Wagner (11/14/2013)


    whereisSQL? (11/13/2013)


    Delete

    Junk

    Food

    Cooking

    Accountancy

    Books

    Doc Savage

    paperback

    pulp fiction

  • RE: Query to join 3 tables.

    As far as I can tell, what you are asking for is a simple 5-way join: of course in T-SQL that has to written as 4 nested two-way joins -...

  • RE: Today's Random Word!

    Ed Wagner (11/15/2013)


    L' Eomot Inversé (11/14/2013)


    Ed Wagner (11/14/2013)


    whereisSQL? (11/13/2013)


    Delete

    Junk

    Food

    Cooking

    Accountancy

  • RE: Table design and PK design

    As Grant said, the naming issue is not the end of the world, but it can create lack of clarity which can result in confusion; but unlike Grant, I believe...

  • RE: Computed columns Data Types

    Bob Cullen-434885 (11/15/2013)


    Raul, Gaz, thanks both. I should have known better than to assume SQL would apply some intelligence to the expression analysis! 😉

    Odd, though, in the table designer, how...

  • RE: Are the posted questions getting worse?

    dwain.c (11/14/2013)


    Greg Edwards-268690 (11/14/2013)


    Show me the person who is a master of all things SQL Server.

    They are as rare as seeing a unicorn...

    They call this the Asian Unicorn.

    ....

    There now. ...

  • RE: Today's Random Word!

    Ed Wagner (11/14/2013)


    whereisSQL? (11/13/2013)


    Delete

    Junk

    Food

  • RE: Are the posted questions getting worse?

    Lynn Pettis (11/13/2013)


    Lynn Pettis (11/13/2013)


    It is 23:27 Afghan time. Three minutes until my phone interview. Wish me luck!

    Just finished the interview, and I feel like a Junior DBA....

  • RE: REGEX

    alex.d.garland (11/14/2013)


    Mighty (11/14/2013)


    As far as I know SQL Server can only handle REGEX via the CLR, so .NET.

    The queries as shown here were not using REGEX.

    +1

    This was a really good...

  • RE: Are the posted questions getting worse?

    duplicate post - website problem??

  • RE: Are the posted questions getting worse?

    wolfkillj (11/13/2013)


    At least we English-speakers have finally agreed that "billion" means a thousand millions and "trillion" means a million millions!

    I wouldn't put too much reliance on that. In computing...

  • RE: Data Compression

    Jason and Koen have pointed out the flaws in this question.

    I wonder how many people will end up answering (correctly) "developer edition" and finding out that that answer...

  • RE: Today's Random Word!

    Revenant (11/11/2013)


    whereisSQL? (11/11/2013)


    Mamma Mia!

    Abba

    Waterloo

Viewing 15 posts - 2,896 through 2,910 (of 7,484 total)