Forum Replies Created

Viewing 15 posts - 136 through 150 (of 464 total)

  • RE: Today's Random Word!

    crookj (7/13/2016)

    Ed Wagner (7/13/2016)

    eccentricDBA (7/13/2016)

    Grumpy DBA (7/13/2016)

    Stuart Davies (7/13/2016)

    Ed Wagner (7/12/2016)

    Straight

    Lines

    White

    Lies Lies Lies (Violent Femmes)

    Politicians

    Sewage

    Septic

    July 13, 2016 at 8:28 am

    #1889874

  • RE: Today's Random Word!

    crookj (7/12/2016)

    HappyGeek (7/12/2016)

    Manic Star (7/12/2016)

    Revenant (7/12/2016)

    Alan.B (7/12/2016)

    Ed Wagner (7/12/2016)

    djj (7/12/2016)

    whereisSQL? (7/12/2016)

    Ed Wagner (7/12/2016)

    Manic Star (7/12/2016)

    TomThomson (7/12/2016)

    djj (7/12/2016)

    whereisSQL? (7/12/2016)

    Ray K (7/12/2016)

    jasona.work (7/12/2016)

    crookj (7/12/2016)

    Grumpy DBA (7/12/2016)

    Alan.B (7/12/2016)

    attack

    Defend

    Rope-a-Dope

    The Greatest

    Ali

    Clay

    Feet

    Inches

    25.4 Millimeters

    Distance

    Travelled

    Vacation

    Relaxation

    Taxation

    Theft

    Identity

    Card

    Ace

    Hole

    July 12, 2016 at 2:33 pm

    #1889727

  • RE: Today's Random Word!

    Ed Wagner (7/12/2016)

    Manic Star (7/12/2016)

    TomThomson (7/12/2016)

    djj (7/12/2016)

    whereisSQL? (7/12/2016)

    Ray K (7/12/2016)

    jasona.work (7/12/2016)

    crookj (7/12/2016)

    Grumpy DBA (7/12/2016)

    Alan.B (7/12/2016)

    attack

    Defend

    Rope-a-Dope

    The Greatest

    Ali

    Clay

    Feet

    Inches

    25.4 Millimeters

    Distance

    Travelled

    July 12, 2016 at 12:21 pm

    #1889693

  • RE: Today's Random Word!

    Ray K (7/12/2016)

    jasona.work (7/12/2016)

    crookj (7/12/2016)

    Grumpy DBA (7/12/2016)

    Alan.B (7/12/2016)

    attack

    Defend

    Rope-a-Dope

    The Greatest

    Ali

    Clay

    July 12, 2016 at 8:29 am

    #1889619

  • RE: Today's Random Word!

    HappyGeek (7/11/2016)

    Ed Wagner (7/11/2016)

    djj (7/11/2016)

    Y.B. (7/11/2016)

    Luis Cazares (7/11/2016)

    djj (7/11/2016)

    Ray K (7/11/2016)

    Ed Wagner (7/11/2016)

    Lion

    Tiger

    Bears (oh, my)

    Care

    Package

    Amazon

    Prime

    Target

    Practice

    July 11, 2016 at 2:30 pm

    #1889516

  • RE: Today's Random Word!

    Manic Star (7/11/2016)

    djj (7/11/2016)

    BWFC (7/11/2016)

    Ed Wagner (7/11/2016)

    Grumpy DBA (7/11/2016)

    eccentricDBA (7/11/2016)

    Ed Wagner (7/11/2016)

    Manic Star (7/11/2016)

    Luis Cazares (7/11/2016)

    Ed Wagner (7/11/2016)

    Boom

    chick-chicky-boom

    Explosion

    Shrapnel

    collateral damage

    Arnold Schwarzenegger

    Terminator

    Semi-colon

    sigmoid colon

    Sigmund Freud

    Psychoanalysis

    July 11, 2016 at 9:07 am

    #1889441

  • RE: Today's Random Word!

    HappyGeek (7/7/2016)

    djj (7/7/2016)

    crookj (7/7/2016)

    ThomasRushton (7/7/2016)

    djj (7/7/2016)

    Stuart Davies (7/7/2016)

    Manic Star (7/6/2016)

    Revenant (7/6/2016)

    Ed Wagner (7/6/2016)

    djj (7/6/2016)

    Ed Wagner (7/6/2016)

    crookj (7/6/2016)

    whereisSQL? (7/6/2016)

    Manic Star (7/6/2016)

    Unicode

    Standards

    S.O.P.

    Tactics

    Planning

    Strategy

    Go

    Away

    Day

    Tripper

    Acid

    Test

    Rework

    Rethink

    Regret

    July 7, 2016 at 10:39 am

    #1889025

  • RE: Today's Random Word!

    Manic Star (7/6/2016)

    Ed Wagner (7/6/2016)

    whereisSQL? (7/6/2016)

    Ed Wagner (7/6/2016)

    Manic Star (7/6/2016)

    Ed Wagner (7/5/2016)

    Luis Cazares (7/5/2016)

    whereisSQL? (7/5/2016)

    Ed Wagner (7/5/2016)

    Manic Star (7/5/2016)

    Ed Wagner (7/5/2016)

    djj (7/5/2016)

    ThomasRushton (7/5/2016)

    Ed Wagner (7/5/2016)

    Revenant (7/5/2016)

    Y.B. (7/5/2016)

    Ed Wagner (7/5/2016)

    ThomasRushton (7/5/2016)

    Stuart...

    July 6, 2016 at 12:45 pm

    #1888769

  • RE: Today's Random Word!

    Ed Wagner (7/6/2016)

    Manic Star (7/6/2016)

    Ed Wagner (7/5/2016)

    Luis Cazares (7/5/2016)

    whereisSQL? (7/5/2016)

    Ed Wagner (7/5/2016)

    Manic Star (7/5/2016)

    Ed Wagner (7/5/2016)

    djj (7/5/2016)

    ThomasRushton (7/5/2016)

    Ed Wagner (7/5/2016)

    Revenant (7/5/2016)

    Y.B. (7/5/2016)

    Ed Wagner (7/5/2016)

    ThomasRushton (7/5/2016)

    Stuart Davies (7/5/2016)

    Club

    Kitkat

    Candy

    Cane

    Kane [Citizen]

    Sugar

    Barley

    Wheat

    Flour

    E-Coli

    Bacteria

    Super

    Man

    Tools

    Skills

    Paul

    Saul

    July 6, 2016 at 8:27 am

    #1888705

  • RE: TSQL Select specific records and child records from same table

    In your sample data ProjectType was either "new" or "std" there was no empty string ('').

    You are changing it to an empty string in your SELECT statement via CASE. So...

    July 6, 2016 at 8:13 am

    #1888699

  • RE: Today's Random Word!

    Ed Wagner (7/5/2016)

    Manic Star (7/5/2016)

    Ed Wagner (7/5/2016)

    djj (7/5/2016)

    ThomasRushton (7/5/2016)

    Ed Wagner (7/5/2016)

    Revenant (7/5/2016)

    Y.B. (7/5/2016)

    Ed Wagner (7/5/2016)

    ThomasRushton (7/5/2016)

    Stuart Davies (7/5/2016)

    Club

    Kitkat

    Candy

    Cane

    Kane [Citizen]

    Sugar

    Barley

    Wheat

    Flour

    E-Coli

    Bacteria

    Super

    July 5, 2016 at 1:11 pm

    #1888546

  • RE: TSQL Select specific records and child records from same table

    ;WITH NewProjects

    AS

    (

    SELECT Location

    , Finish

    FROM Projects

    WHERE ProjectType = 'New'

    )

    SELECT p.ProjectNo

    , CASE p.ProjectType WHEN 'New' THEN p.ProjectType ELSE '' END AS ProjectType

    , p.Location

    , CASE WHEN (p.ProjectType <> 'New') AND (ABS(DATEDIFF(month, p.Finish,...

    July 5, 2016 at 1:00 pm

    #1888542

  • RE: Today's Random Word!

    Grumpy DBA (7/1/2016)

    djj (7/1/2016)

    Manic Star (7/1/2016)

    Ed Wagner (7/1/2016)

    Manic Star (7/1/2016)

    Grumpy DBA (7/1/2016)

    Luis Cazares (7/1/2016)

    Bunnies

    Beach

    Umbrella

    Fancy Drink

    mmmm....beer

    Brew

    IPA

    hops

    July 1, 2016 at 12:58 pm

    #1888146

  • RE: TSQL Select specific records and child records from same table

    ;WITH NewProjects

    AS

    (

    SELECT Location

    FROM projects

    WHERE ProjectType = 'New'

    )

    SELECT p.ProjectNo

    ,p.ProjectType

    ,p.Location

    FROM NewProjects AS np

    JOIN Projects AS p ON p.Location = np.Location

    ORDER BY p.Location ASC

    First I identified the projects with type New in...

    July 1, 2016 at 12:49 pm

    #1888143

  • RE: Today's Random Word!

    Ed Wagner (6/22/2016)

    djj (6/22/2016)

    Ed Wagner (6/22/2016)

    Manic Star (6/22/2016)

    Ed Wagner (6/22/2016)

    Luis Cazares (6/22/2016)

    Revenant (6/22/2016)

    ThomasRushton (6/22/2016)

    Manic Star (6/22/2016)

    Ed Wagner (6/22/2016)

    Grumpy DBA (6/22/2016)

    Ed Wagner (6/22/2016)

    Performance

    Review

    Rate

    Raise

    Drawbridge

    Castle

    Palace

    Royalty

    Glitterati

    Paparazzi

    Photograph

    Def Leppard

    Band

    June 22, 2016 at 1:49 pm

    #1886386

Viewing 15 posts - 136 through 150 (of 464 total)