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...

  • 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

  • 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...

  • 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...

  • 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...

  • 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...

  • 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...

  • 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...

  • 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

  • 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...

  • RE: Today's Random Word!

    SQLRNNR (6/13/2014)


    corner

    penalty

  • 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....

  • 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:

  • 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...

  • 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...

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