Forum Replies Created

Viewing 15 posts - 631 through 645 (of 3,957 total)

  • RE: Are the posted questions getting worse?

    Ville-Pekka Vahteala (3/28/2014)

    TomThomson (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 full of these pieces of...

    March 30, 2014 at 5:45 pm

    #1701450

  • RE: Are the posted questions getting worse?

    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 full of these pieces...

    March 30, 2014 at 5:34 pm

    #1701449

  • RE: Are the posted questions getting worse?

    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 full of these pieces of...

    March 30, 2014 at 5:32 pm

    #1701447

  • RE: Are the posted questions getting worse?

    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 full of these pieces of sh code and...

    March 28, 2014 at 2:56 am

    #1701009

  • RE: Are the posted questions getting worse?

    jcrawf02 (3/27/2014)

    Grant Fritchey (3/25/2014)

    The Dixie Flatline (3/25/2014)

    My poster child interview disappointment: Good resume' on paper, but then the man walked in, opened up his laptop, and scrolled...

    March 27, 2014 at 7:14 pm

    #1700953

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (3/27/2014)

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

    Nice Koen! Congrats and keep up the good work!

    March 27, 2014 at 7:10 pm

    #1700952

  • RE: Reaping the benefits of the Window functions in T-SQL

    Eirikur Eiriksson (3/25/2014)

    Looks like JM's seal of approval, which doesn't come easily.

    Well done indeed!

    Thanks Dwain :Wow:

    You also get my seal of approval. 🙂

    Tally Tables in T-SQL[/url]

    Reference and link at the...

    March 27, 2014 at 5:43 am

    #1700632

  • RE: Finding Gaps in Dates

    Perhaps this article will be what you need:

    Calculating Gaps Between Overlapping Time Intervals in SQL[/url]

    March 25, 2014 at 6:15 pm

    #1700102

  • RE: Are the posted questions getting worse?

    Greg Edwards-268690 (3/25/2014)

    WayneS (3/25/2014)

    Greg Edwards-268690 (3/24/2014)

    It would be really scary if he was hired through any kind of interview process.

    But... I've been working in SQL for 10 years... I'm a...

    March 25, 2014 at 5:51 pm

    #1700100

  • RE: Reaping the benefits of the Window functions in T-SQL

    Jeff Moden (3/24/2014)

    dwain.c (3/24/2014)

    Interesting article. I'm curious to see what comments Jeff has about it.

    Eirikur asked me to review it (seems like a couple/three months ago) and I'm tickled...

    March 24, 2014 at 6:11 pm

    #1699710

  • RE: Reaping the benefits of the Window functions in T-SQL

    Interesting article. I'm curious to see what comments Jeff has about it.

    March 24, 2014 at 3:16 am

    #1699431

  • RE: How to find a missing sequence in a column?

    I think the link is fixed now. The article doesn't say why it is faster, just provides an example that shows that it does.

    If you've got a gap on...

    March 21, 2014 at 6:33 pm

    #1699289

  • RE: How to find a missing sequence in a column?

    If all you want is the RefIDs that are missing one or more row numbers, that's really easy:

    WITH SampleData (ID, RefID, SeqNo, Name) AS

    (

    select 1, 1000,...

    March 20, 2014 at 7:08 pm

    #1698926

  • RE: Data Manipulation Question

    Jeff Moden (3/20/2014)

    @Dwain,

    Thanks for the awesome compliments. :blush: I just aim to help. I sometimes miss but I'm always aiming. 🙂

    I noticed the links problem when I...

    March 20, 2014 at 5:49 pm

    #1698925

  • RE: Data Manipulation Question

    SQLSeTTeR (3/19/2014)

    Never played with CROSS Tab. Do you have an example I can play around with?

    I looked into books online but not sure if I'm looking at the right thing...

    March 20, 2014 at 12:11 am

    #1698573

Viewing 15 posts - 631 through 645 (of 3,957 total)