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

    March 2, 2015 at 7:22 am

    #1781099

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

    February 27, 2015 at 6:56 am

    #1780576

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

    February 27, 2015 at 6:54 am

    #1780575

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

    February 26, 2015 at 6:23 am

    #1780214

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

    February 26, 2015 at 1:27 am

    #1780130

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

    February 25, 2015 at 6:59 am

    #1779897

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

    February 24, 2015 at 9:58 am

    #1779657

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

    February 24, 2015 at 6:56 am

    #1779572

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

    February 24, 2015 at 2:10 am

    #1779506

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

    February 24, 2015 at 1:37 am

    #1779498

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

    February 23, 2015 at 8:24 am

    #1779276

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

    February 23, 2015 at 1:59 am

    #1779201

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

    February 19, 2015 at 1:42 am

    #1778558

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

    February 19, 2015 at 1:35 am

    #1778555

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

    February 19, 2015 at 1:32 am

    #1778554

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