Forum Replies Created

Viewing 15 posts - 3,421 through 3,435 (of 9,399 total)

  • RE: Today's Random Word!

    Revenant (4/5/2016)

    crookj (4/5/2016)

    Ed Wagner (4/5/2016)

    djj (4/5/2016)

    crookj (4/5/2016)

    djj (4/5/2016)

    Ed Wagner (4/5/2016)

    djj (4/5/2016)

    BL0B_EATER (4/5/2016)

    whereisSQL? (4/5/2016)

    BWFC (4/5/2016)

    ZZartin (4/5/2016)

    Grumpy DBA (4/5/2016)

    Ed Wagner (4/5/2016)

    Sunrise

    Sunset

    Pegasus

    Bridge

    Canal

    water

    River

    Sea

    Horse

    Mr Ed

    Wilber

    Pig

    Latin

    Greek

    Rome

    April 5, 2016 at 11:16 am

    #1869920

  • RE: Are the posted questions getting worse?

    Grant Fritchey (4/5/2016)

    SQLRNNR (4/5/2016)

    Grant Fritchey (4/5/2016)

    Phil Parkin (4/5/2016)

    Gail and I are gamely persevering with this one. I think my pressure limit has been reached now, though.

    Oh god...

    "The delete works sometimes"

    ......

    April 5, 2016 at 11:14 am

    #1869918

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (4/5/2016)

    Sean Lange (4/5/2016)

    Luis Cazares (4/5/2016)

    Phil Parkin (4/5/2016)

    Gail and I are gamely persevering with this one. I think my pressure limit has been reached now, though.

    I constantly avoid that...

    April 5, 2016 at 11:11 am

    #1869915

  • RE: Today's Random Word!

    djj (4/5/2016)

    crookj (4/5/2016)

    djj (4/5/2016)

    Ed Wagner (4/5/2016)

    djj (4/5/2016)

    BL0B_EATER (4/5/2016)

    whereisSQL? (4/5/2016)

    BWFC (4/5/2016)

    ZZartin (4/5/2016)

    Grumpy DBA (4/5/2016)

    Ed Wagner (4/5/2016)

    Sunrise

    Sunset

    Pegasus

    Bridge

    Canal

    water

    River

    Sea

    Horse

    Mr Ed

    Wilber

    Pig

    April 5, 2016 at 10:08 am

    #1869880

  • RE: Are the posted questions getting worse?

    Phil Parkin (4/5/2016)

    Gail and I are gamely persevering with this one. I think my pressure limit has been reached now, though.

    I don't know whether it's more funny or sad. ...

    April 5, 2016 at 10:07 am

    #1869879

  • RE: Today's Random Word!

    djj (4/5/2016)

    BL0B_EATER (4/5/2016)

    whereisSQL? (4/5/2016)

    BWFC (4/5/2016)

    ZZartin (4/5/2016)

    Grumpy DBA (4/5/2016)

    Ed Wagner (4/5/2016)

    Sunrise

    Sunset

    Pegasus

    Bridge

    Canal

    water

    River

    Sea

    April 5, 2016 at 9:07 am

    #1869846

  • RE: Today's Random Word!

    djj (4/5/2016)

    Ed Wagner (4/5/2016)

    Jeff Moden (4/4/2016)

    TomThomson (4/4/2016)

    Ed Wagner (4/4/2016)

    djj (4/4/2016)

    Manic Star (4/4/2016)

    djj (4/4/2016)

    Grumpy DBA (4/4/2016)

    ZZartin (4/4/2016)

    crookj (4/4/2016)

    ThomasRushton (4/4/2016)

    crookj (4/4/2016)

    Ed Wagner (4/4/2016)

    Grumpy DBA (4/4/2016)

    DonlSimpson (4/4/2016)

    Redsox

    WhiteSox

    Cubs

    Skysox

    SmellySocks

    Deadsox (All zombie team)

    Mutant

    Ninja

    Turtle

    Shell

    Wax

    Car

    Park

    PRNDL

    Shift

    Night

    Sunrise

    April 5, 2016 at 5:14 am

    #1869763

  • RE: Which properties exist?

    I've never used it either. Learning something is always a good way to start the day.

    April 5, 2016 at 4:15 am

    #1869748

  • RE: Today's Random Word!

    Jeff Moden (4/4/2016)

    TomThomson (4/4/2016)

    Ed Wagner (4/4/2016)

    djj (4/4/2016)

    Manic Star (4/4/2016)

    djj (4/4/2016)

    Grumpy DBA (4/4/2016)

    ZZartin (4/4/2016)

    crookj (4/4/2016)

    ThomasRushton (4/4/2016)

    crookj (4/4/2016)

    Ed Wagner (4/4/2016)

    Grumpy DBA (4/4/2016)

    DonlSimpson (4/4/2016)

    Redsox

    WhiteSox

    Cubs

    Skysox

    SmellySocks

    Deadsox (All zombie team)

    Mutant

    Ninja

    Turtle

    Shell

    Wax

    Car

    Park

    PRNDL

    Shift

    April 5, 2016 at 4:14 am

    #1869747

  • RE: Today's Random Word!

    djj (4/4/2016)

    Manic Star (4/4/2016)

    djj (4/4/2016)

    Grumpy DBA (4/4/2016)

    ZZartin (4/4/2016)

    crookj (4/4/2016)

    ThomasRushton (4/4/2016)

    crookj (4/4/2016)

    Ed Wagner (4/4/2016)

    Grumpy DBA (4/4/2016)

    DonlSimpson (4/4/2016)

    Redsox

    WhiteSox

    Cubs

    Skysox

    SmellySocks

    Deadsox (All zombie team)

    Mutant

    Ninja

    Turtle

    Shell

    Wax

    Car

    April 4, 2016 at 2:41 pm

    #1869646

  • RE: Find out the record with that falls in the date range

    Ed Wagner (4/4/2016)

    What happens when you have this scenario?

    INSERT INTO #temp

    SELECT '123', 20.00, '20140101', '20140131'

    UNION

    SELECT '123', 25.00, '20140101', '20140131'

    Or this:

    INSERT INTO #temp

    SELECT '123', 20.00, '20140101', NULL

    UNION

    SELECT '123', 25.00, '20140101', NULL

    If...

    April 4, 2016 at 10:19 am

    #1869586

  • RE: Find out the record with that falls in the date range

    What happens when you have this scenario?

    INSERT INTO #temp

    SELECT '123', 20.00, '20140101', '20140131'

    UNION

    SELECT '123', 25.00, '20140101', '20140131'

    Or this:

    INSERT INTO #temp

    SELECT '123', 20.00, '20140101', NULL

    UNION

    SELECT '123', 25.00, '20140101', NULL

    April 4, 2016 at 10:05 am

    #1869583

  • RE: Today's Random Word!

    crookj (4/4/2016)

    Ed Wagner (4/4/2016)

    Grumpy DBA (4/4/2016)

    DonlSimpson (4/4/2016)

    Redsox

    WhiteSox

    Cubs

    Skysox

    Skybox

    April 4, 2016 at 10:00 am

    #1869578

  • RE: Today's Random Word!

    Grumpy DBA (4/4/2016)

    DonlSimpson (4/4/2016)

    Redsox

    WhiteSox

    Cubs

    April 4, 2016 at 9:30 am

    #1869560

  • RE: What is the best to remove xp_cmdshell calls from t-sql code

    If it were me, I'd prefer Lowell's first approach as opposed to a database job. The procedure, having permissions to use xp_cmdshell, must be running with sysadmin privs, so...

    April 4, 2016 at 7:45 am

    #1869513

Viewing 15 posts - 3,421 through 3,435 (of 9,399 total)