Forum Replies Created

Viewing 15 posts - 4,456 through 4,470 (of 15,381 total)

  • RE: Code for top 1 results giving 0 results???

    There are a number of things that could be the issue here.

    How about this subselect.

    SELECT ITEM_SK FROM GROUP_ITEMS WHERE GROUP_CODE = 'APPTTY' AND DESCRIPTION = 'TRIAL'

    If you run that all...

    June 13, 2014 at 2:45 pm

    #1721663

  • RE: Today's Random Word!

    Ed Wagner (6/13/2014)

    SQLRNNR (6/13/2014)

    Sean Lange (6/13/2014)

    SQLRNNR (6/13/2014)

    Ed Wagner (6/13/2014)

    SQLRNNR (6/13/2014)

    Sean Lange (6/13/2014)

    SQLRNNR (6/13/2014)

    corner

    penalty

    off-sides

    hands

    PK

    Dive

    flop-artist

    Showboat

    Neymar

    June 13, 2014 at 2:29 pm

    #1721659

  • RE: get sum of counts from two different queries result set

    Hi and welcome to the forums. In order to help we will need a few things:

    1. Sample DDL in the form of CREATE TABLE statements

    2. Sample data in the form...

    June 13, 2014 at 1:34 pm

    #1721651

  • RE: Are the posted questions getting worse?

    Lynn Pettis (6/13/2014)

    I miss getting out on the pitch with the kids. It actually helps keep me feeling young.

    You should get out and play. That will really help you...

    June 13, 2014 at 1:23 pm

    #1721648

  • RE: Grouping Dates in a Table by 4 weeks at a time

    Tallboy (6/13/2014)

    output should be...

    Output for each employee would be 1 row for each 4 week period as follows;

    PersonnelNo, 4WeekEnd, TotalWorkedHours, TotalContractHours

    1234, 1/10/14, 42.75, 82.00

    1234, 2/9/14, 34.50, 82.00

    4343, 1/10/14, 34.00, 74.00

    This...

    June 13, 2014 at 1:22 pm

    #1721647

  • RE: Are the posted questions getting worse?

    GilaMonster (6/13/2014)

    I hate soccer season.

    hehe soccer isn't really a season per se. Especially those of us in the U.S. We have MLS in the summer and all the other leagues...

    June 13, 2014 at 12:28 pm

    #1721628

  • RE: Validation of a Parent - Child relationship

    Luis Cazares (6/13/2014)

    Thinking again, I might suggest a trigger approach on the case that you can soft-delete contracts with out soft-deleting the organisation. Using the FK approach, you wouldn't be...

    June 13, 2014 at 12:22 pm

    #1721623

  • RE: Are the posted questions getting worse?

    Luis Cazares (6/13/2014)

    SQLRNNR (6/13/2014)

    The Dixie Flatline (6/13/2014)

    Sean Lange (6/13/2014)

    I hope I don't have to avoid SSC for the next month so I don't hear scores before I am able to...

    June 13, 2014 at 12:19 pm

    #1721621

  • RE: Today's Random Word!

    SQLRNNR (6/13/2014)

    Ed Wagner (6/13/2014)

    SQLRNNR (6/13/2014)

    Sean Lange (6/13/2014)

    SQLRNNR (6/13/2014)

    corner

    penalty

    off-sides

    hands

    PK

    Dive

    June 13, 2014 at 12:05 pm

    #1721609

  • RE: Are the posted questions getting worse?

    Grant Fritchey (6/13/2014)

    Sean Lange (6/13/2014)

    Grant Fritchey (6/13/2014)

    NOt a great game, but not a bad one so far. First one I've had on so far this World Cup. I missed last...

    June 13, 2014 at 10:53 am

    #1721577

  • RE: Today's Random Word!

    SQLRNNR (6/13/2014)

    corner

    penalty

    June 13, 2014 at 10:51 am

    #1721575

  • RE: Are the posted questions getting worse?

    Grant Fritchey (6/13/2014)

    NOt a great game, but not a bad one so far. First one I've had on so far this World Cup. I missed last night's game with Brazil....

    June 13, 2014 at 10:44 am

    #1721569

  • RE: Are the posted questions getting worse?

    I hope I don't have to avoid SSC for the next month so I don't hear scores before I am able to watch the games on my DVR. :w00t:

    June 13, 2014 at 10:40 am

    #1721567

  • RE: Splitting a single column into multiple rows

    mdaddiction (6/13/2014)

    Sean, thanks for the advice and the KUDOS. I've been tasked with cleaning up the DB of my predecessor. I'll actually be implementing the solution for several different data...

    June 13, 2014 at 10:38 am

    #1721565

  • RE: Are the posted questions getting worse?

    Luis Cazares (6/13/2014)

    Please do not disturb.

    Watching the World Cup and cheering for Mexico!:-D

    I won't tell anyone you are not at your desk. 😛 I imagine that most of the country...

    June 13, 2014 at 10:12 am

    #1721553

Viewing 15 posts - 4,456 through 4,470 (of 15,381 total)