Forum Replies Created

Viewing 15 posts - 8,236 through 8,250 (of 9,399 total)

  • RE: DELETE FIRST 1000 ROWS

    Once you determine what determines the first rows, I like using this approach:

    WITH cte AS (

    SELECT TOP 1000

    FROM TableName

    ORDER BY...

    March 31, 2014 at 12:03 pm

    #1701733

  • RE: Today's Random Word!

    Revenant (3/31/2014)

    SQLRNNR (3/31/2014)

    BWFC (3/31/2014)

    Kurt W. Zimmerman (3/31/2014)

    knucklehead

    Drummer Caveman

    Knuckledragger

    Borderlands

    Doom

    March 31, 2014 at 9:43 am

    #1701662

  • RE: Today's Random Word!

    BWFC (3/31/2014)

    TomThomson (3/28/2014)

    Kurt W. Zimmerman (3/28/2014)

    Micro

    Scope

    Scale

    Slide

    March 31, 2014 at 5:06 am

    #1701534

  • RE: Default schema

    I agree with most of the previous posters here - that exception was pretty weak. I suppose it might be a problem if the login didn't exist or if...

    March 31, 2014 at 5:00 am

    #1701531

  • RE: Today's Random Word!

    bcsims 90437 (3/28/2014)

    Eric M Russell (3/28/2014)

    Ed Wagner (3/28/2014)

    SQLRNNR (3/28/2014)

    JAZZ Master (3/28/2014)

    Revenant (3/28/2014)

    Ed Wagner (3/28/2014)

    Kurt W. Zimmerman (3/28/2014)

    SQLRNNR (3/28/2014)

    Ed Wagner (3/28/2014)

    Row

    Roe

    Wade

    Deep

    Purple

    Rain

    Cry

    Dove

    Tail

    spiral

    Downward

    March 28, 2014 at 12:35 pm

    #1701281

  • RE: Are the posted questions getting worse?

    GilaMonster (3/28/2014)

    Ed Wagner (3/28/2014)

    Grant - You have booth babes??? :w00t:

    Grant *is* the booth 'babe' 🙂

    Oh boy - I should have kept my mouth shut. Please, no pictures and nothing...

    March 28, 2014 at 9:19 am

    #1701178

  • RE: Today's Random Word!

    SQLRNNR (3/28/2014)

    JAZZ Master (3/28/2014)

    Revenant (3/28/2014)

    Ed Wagner (3/28/2014)

    Kurt W. Zimmerman (3/28/2014)

    SQLRNNR (3/28/2014)

    Ed Wagner (3/28/2014)

    Row

    Roe

    Wade

    Deep

    Purple

    Rain

    Cry

    Dove

    March 28, 2014 at 9:10 am

    #1701171

  • RE: Are the posted questions getting worse?

    Grant Fritchey (3/28/2014)

    Jeff Moden (3/28/2014)

    SQLRNNR (3/28/2014)

    Sean Lange (3/28/2014)

    dwain.c (3/28/2014)

    Ville-Pekka Vahteala (3/27/2014)

    Luis Cazares (3/27/2014)

    How is it possible that someone writes a cursor instead of using SUM()?

    I'm afraid that this database is...

    March 28, 2014 at 9:10 am

    #1701169

  • RE: Today's Random Word!

    Kurt W. Zimmerman (3/28/2014)

    SQLRNNR (3/28/2014)

    Ed Wagner (3/28/2014)

    Row

    Roe

    Wade

    Deep

    March 28, 2014 at 7:34 am

    #1701086

  • RE: Today's Random Word!

    EricEyster (3/28/2014)

    Ed Wagner (3/28/2014)

    Row

    Boat

    Expensive

    March 28, 2014 at 5:56 am

    #1701043

  • RE: Are the posted questions getting worse?

    WayneS (3/27/2014)

    Luis Cazares (3/27/2014)

    How is it possible that someone writes a cursor instead of using SUM()?

    I'm afraid that this database is full of these pieces of sh code and it's...

    March 28, 2014 at 5:46 am

    #1701041

  • RE: Today's Random Word!

    Row

    March 28, 2014 at 5:25 am

    #1701033

  • RE: Schema confusion

    RBarryYoung (3/27/2014)

    There is also a Schema with the same name. I am not sure how or why, but in some databases, matching schemas get created whenever a user is...

    March 27, 2014 at 1:20 pm

    #1700863

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (3/27/2014)

    W00t w00t, this one makes my 12000th point. 😎

    Well done, Koen.

    March 27, 2014 at 9:12 am

    #1700729

  • RE: The Unusable User

    That was a very interesting question. It a process of elimination to get it down to 2 possibilities and the coffee made me wonder if the database context was...

    March 27, 2014 at 6:17 am

    #1700645

Viewing 15 posts - 8,236 through 8,250 (of 9,399 total)