Forum Replies Created

Viewing 15 posts - 2,596 through 2,610 (of 10,144 total)

  • RE: Using DelimitedSplit8K

    Can you post a set of data for table from [co_audit_trail] au please? DDL and DML. It will make this exercise much easier for folks to work on if...

  • RE: Are the posted questions getting worse?

    Lynn Pettis (2/26/2015)


    ... Mark one off, 1 day on the calendar to go. 1 day on the calendar to go, 1 day to go, ...

    Happy travels Lynn, hope everything goes...

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (2/26/2015)


    ChrisM@Work (2/26/2015)


    BWFC (2/26/2015)


    Ed Wagner (2/26/2015)


    Jeff Moden (2/25/2015)


    Lynn Pettis (2/25/2015)


    ... Mark one off, 2 days on the calendar to go. 2 days on the calendar to go, 2 days...

  • RE: Are the posted questions getting worse?

    BWFC (2/26/2015)


    Ed Wagner (2/26/2015)


    Jeff Moden (2/25/2015)


    Lynn Pettis (2/25/2015)


    ... Mark one off, 2 days on the calendar to go. 2 days on the calendar to go, 2 days to go, ...

    And...

  • RE: Are the posted questions getting worse?

    Jeff Moden (2/25/2015)


    Brandie Tarvin (2/25/2015)


    Need some advice, all. I'm about to rewrite a novel of mine and I need references for research. My protagonist (the star) is humanoid but not...

  • RE: Sql query need to be updated as group by

    Wild guess:

    SELECT

    a.U_Empid AS [SAP ID],

    OHEM.U_IQId AS [Iqama No],

    ISNULL(OHEM.firstName,'') + ISNULL(' ' + OHEM.middleName,'') + ISNULL(' ' + OHEM.lastName,'') AS [Employee Name],

    OUDP.Remarks AS [Department],

    a.U_PyrlMnth AS [Work Month],

    a.U_ProjectCode AS [Project...

  • RE: WHERE 1 = 1,who uses this besides me

    SQLRNNR (2/24/2015)


    ChrisM@Work (2/24/2015)


    Dogma spawns bad code as efficiently as laziness and ignorance.

    Nice. Great quote. I'm gonna use it now.:-D

    That’s Plan B. Plan A was one of those 30-plus-letter...

  • RE: Dynamically Query a 100 Million Row Table-Efficiently

    gary.strange-sqlconsumer (2/24/2015)


    Adam is my brother, an awsome System Admin.

    and Chris must be his colleague. Took me a little while to figure that one out. 😀

    He is awesome, but don't tell...

  • RE: WHERE 1 = 1,who uses this besides me

    PHYData DBA (2/23/2015)


    ChrisM@Work (2/23/2015)


    PHYData DBA (2/23/2015)

    Care to divulge?

    Since you did not specify I am going to just restate one that this discussion is about -

    Never add a where statement to...

  • RE: Dynamically Query a 100 Million Row Table-Efficiently

    Very good article Gary, I gave it five stars because you covered the ground with some excellent explanations. Two omissions stood out however - the cost of recompiling, and why...

  • RE: WHERE 1 = 1,who uses this besides me

    PHYData DBA (2/23/2015)


    bantrim (2/22/2015)


    Eric M Russell (2/22/2015)


    On occasion I've used: SELECT.. WHERE 1 = 0. For example, I may want to select into a temp table that is derived from...

  • RE: Are the posted questions getting worse?

    rodjkidd (2/21/2015)


    Chris,

    I've just realised I'm going to Shepherds Bush Thursday night - Trevor Horn Band is playing a one off gig with Seal as special guest. So it will have...

  • RE: Query Causing Blocking, Locks Table for 1000 Seconds, Help Needed!

    sgmunson (2/18/2015)


    Velveeta22 (2/17/2015)


    Matched the column names to the original stuck query and added friendly alias'. Results pull matching data in both test and prod (fresh data). My hope...

  • RE: WHERE 1 = 1,who uses this besides me

    DonlSimpson (2/18/2015)


    ...

    I think it's just lazy though.

    When "lazy" translates to "quick, easy and accurate" it's not so bad.

  • RE: WHERE 1 = 1,who uses this besides me

    Eric M Russell (2/18/2015)


    Eric M Russell (2/18/2015)


    Resender (2/2/2015)


    ok this is something of a best practice of mine in my queries

    I always do

    WHERE 1 = 1

    I can't remember where I picked...

Viewing 15 posts - 2,596 through 2,610 (of 10,144 total)