Forum Replies Created

Viewing 15 posts - 1,081 through 1,095 (of 10,144 total)

  • RE: Are the posted questions getting worse?

    Jeff Moden (12/7/2016)

    This Saturday, 12/10, marks the anniversary of a very unhappy event for me. It's the day that Dwain Camps fell to cancer. Dwain was a...

    December 8, 2016 at 3:39 am

    #1916702

  • RE: Are the posted questions getting worse?

    rodjkidd (12/7/2016)

    Eirikur,

    I'm about a 20 minute walk to the High Holborn Caffe 1882. Let me know if you still want to meet up today?

    Chris, are you about?

    Rodders...

    Oh poo. Sorry I...

    December 8, 2016 at 3:32 am

    #1916701

  • RE: Increase speed of WHILE LOOP with INSERT

    Talvin Singh (12/1/2016)

    I cant do that. thats assuming the top 1000 get added. a sku dataset may have 20000 and i need to randomly select 2000, not the...

    December 1, 2016 at 10:12 am

    #1915499

  • RE: Increase speed of WHILE LOOP with INSERT

    Talvin Singh (12/1/2016)

    Hi,

    i have the following code:

    WHILE (SELECT COUNT(*) FROM tblSKUGrown) < 1000

    BEGIN

    INSERT INTO tblSKUGrown (SKU, OL)

    (SELECT CONCAT(x.SKU,'_n'), x.OL FROM

    (

    SELECT

    ROW_NUMBER() OVER (ORDER BY s.OL desc) AS Row,

    s.SKU,

    s.OL

    FROM RAW_skus s

    )x

    WHERE...

    December 1, 2016 at 9:52 am

    #1915483

  • RE: Are the posted questions getting worse?

    TomThomson (11/30/2016)

    ChrisM@Work (11/30/2016)

    Eirikur chose his workplace well - in addition to the coffee, there's a very fine pub almost next door too. I'm in NYNY this weekend, would be awesome...

    December 1, 2016 at 1:43 am

    #1915335

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (11/30/2016)

    UAT testing on new forums has started. In addition, a large internal bug hunt from random RG people last week found a few usability, and...

    November 30, 2016 at 9:28 am

    #1915213

  • RE: Coalesce and Case

    dsmith402 (11/29/2016)

    Ok, that certainly makes sense. But how would this expression be re-written in order for it to work?

    Drop the COALESCE, it's redundant and confusing.

    CASE

    WHEN FSI.FID IN ('1800','1810') AND FSI.StepCompletion...

    November 30, 2016 at 2:41 am

    #1915109

  • RE: Are the posted questions getting worse?

    rodjkidd (11/29/2016)

    Eirikur Eiriksson (11/29/2016)

    rodjkidd (11/29/2016)

    Eirikur Eiriksson (11/24/2016)

    Gazareth (11/24/2016)

    Eirikur Eiriksson (11/24/2016)

    Gazareth (11/24/2016)

    BWFC (11/24/2016)

    ThomasRushton (11/24/2016)

    BLOB EATER (11/24/2016)

    GilaMonster (11/24/2016)

    Brandie Tarvin (11/24/2016)

    Much prefer chocolate or herbal tea (decaf).

    The office kitchen also caters to stranger...

    November 30, 2016 at 2:33 am

    #1915107

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (11/28/2016)

    My daughter grinds beans each morning for her french press and froths milk. She usually makes enough to give me a cup 😉

    I've not heard...

    November 29, 2016 at 1:48 am

    #1914880

  • RE: Are the posted questions getting worse?

    Luis Cazares (11/23/2016)

    Steve Jones - SSC Editor (11/23/2016)

    robert.sterbal 56890 (11/23/2016)

    What is on your menu for Thanksgiving?

    Can you share any recipes?

    Our family will be having Thanksgiving at my wife's parents with...

    November 23, 2016 at 9:33 am

    #1914268

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (11/23/2016)

    Because I won't be online tomorrow (or probably Friday), Happy Turkey Day to all who celebrate. Or Tofurkey Day, whichever floats your boat.

    Enjoy the holiday!

    Or even this scary...

    November 23, 2016 at 5:05 am

    #1914191

  • RE: Number of logical reads very different between 2 supposed identical environments

    Beatrix Kiddo (11/23/2016)

    I really enjoyed reading that, Hugo.

    Absolutely likewise!

    It's 85% of a cracking good article, and an important one also. Row goal queries can have astonishingly bad plans, at...

    November 23, 2016 at 2:00 am

    #1914170

  • RE: Are the posted questions getting worse?

    BWFC (11/18/2016)

    I've not tried it yet but it's definitely on the agenda. The next thing on the curing list is a ham. Hopefully I've not left it too late...

    November 18, 2016 at 6:42 am

    #1913407

  • RE: Are the posted questions getting worse?

    BWFC (11/18/2016)

    ChrisM@Work (11/18/2016)

    Eirikur Eiriksson (11/18/2016)

    BWFC (11/18/2016)

    TomThomson (11/17/2016)

    BWFC (11/16/2016)

    Sean Lange (11/15/2016)

    Ed Wagner (11/15/2016)

    Y.B. (11/15/2016)

    Hey Brandie, cheddar is not better!! LOL (it's all personal preference of course)

    That being said I did...

    November 18, 2016 at 2:26 am

    #1913351

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (11/18/2016)

    BWFC (11/18/2016)

    TomThomson (11/17/2016)

    BWFC (11/16/2016)

    Sean Lange (11/15/2016)

    Ed Wagner (11/15/2016)

    Y.B. (11/15/2016)

    Hey Brandie, cheddar is not better!! LOL (it's all personal preference of course)

    That being said I did recently try...

    November 18, 2016 at 2:03 am

    #1913341

Viewing 15 posts - 1,081 through 1,095 (of 10,144 total)