Forum Replies Created

Viewing 15 posts - 556 through 570 (of 1,228 total)

  • RE: Comparing data row by row....

    Evil Kraig F (1/20/2012)

    ChrisM@home (1/20/2012)

    Evil Kraig F (1/20/2012)

    ChrisM@home (1/20/2012)

    - don't treat a problem as islands-n-gaps if it isn't, because whatever method you use to resolve it, it's going to cost...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    January 20, 2012 at 4:22 pm

    #1436765

  • RE: Comparing data row by row....

    Evil Kraig F (1/20/2012)

    ChrisM@home (1/20/2012)

    - don't treat a problem as islands-n-gaps if it isn't, because whatever method you use to resolve it, it's going to cost you.

    Chris,

    The only problem with...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    January 20, 2012 at 2:28 pm

    #1436756

  • RE: Comparing data row by row....

    It was worth spending a little time on this to compare island-n-gap resolution by conventional means against a rCTE method.

    Firstly, this thread isn't island-n-gaps because the sequence column is...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    January 20, 2012 at 2:00 pm

    #1436741

  • RE: Is there a more efficient alternative to WHILE LOOPS and CURSORS

    Evil Kraig F (1/19/2012)

    ChrisM@home (1/19/2012)

    Evil Kraig F (1/19/2012)

    s.njenga (1/18/2012)

    Your query is only referencing @introwno ones instead of referencing all rows in the staging table without having to loop through each...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    January 19, 2012 at 12:22 pm

    #1436122

  • RE: Is there a more efficient alternative to WHILE LOOPS and CURSORS

    Evil Kraig F (1/19/2012)

    s.njenga (1/18/2012)

    Your query is only referencing @introwno ones instead of referencing all rows in the staging table without having to loop through each row.

    If that's in reference...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    January 19, 2012 at 11:42 am

    #1436101

  • RE: Are the posted questions getting worse?

    L' Eomot Inversé (1/18/2012)

    Jack Corbett (1/18/2012)

    I assume I'm not the only one who sees no content (well really only the word "content") in the body of today's featured...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    January 19, 2012 at 7:23 am

    #1435829

  • RE: Is there a more efficient alternative to WHILE LOOPS and CURSORS

    Evil Kraig F (1/18/2012)

    Roughly sure this is what you need:

    You're missing an AND from the BETWEEN in the cross apply 😉

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    January 18, 2012 at 3:12 pm

    #1435569

  • RE: Is there a more efficient alternative to WHILE LOOPS and CURSORS

    Evil Kraig F (1/18/2012)

    Ow, my head hurts wrapping around this logic. I'll have to come back to it, but for anyone looking for an easier read, here's the query...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    January 18, 2012 at 3:05 pm

    #1435562

  • RE: Dynamic SQL Error

    And next, for speed, convert this:

    + ' and CONVERT(varchar(4),RETAIL_SALES.YR) + Right(''0'' + CONVERT(varchar(3),RETAIL_SALES.MO),2) + CONVERT(varchar(1),RETAIL_SALES.WK) <= ''' + @EndDate + ''''

    to something like this:

    AND RETAIL_SALES.YR = YEAR(@EndDate ) etc

    which...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    January 18, 2012 at 2:10 pm

    #1435508

  • RE: Dynamic SQL Error

    jayw-1061726 (1/18/2012)

    I was missing the space. Thanks Chris.

    You're welcome, thanks for the feedback. Just out of curiosity, why are you using dynamic SQL for this? Is there a chunk of...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    January 18, 2012 at 1:37 pm

    #1435485

  • RE: Dynamic SQL Error

    Dave Ballantyne (1/18/2012)

    agreed sp_executesql should *always* be used. But quite why dynamic sql is even being used here is anyones guess 🙂

    I'd guess it's not the whole picture, Dave.

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    January 18, 2012 at 1:35 pm

    #1435484

  • RE: Dynamic SQL Error

    It may be a missing space between the FROM and the WHERE.

    The easiest way to find out is to print the full string, copy and paste it into a...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    January 18, 2012 at 11:56 am

    #1435432

  • RE: Help with Counts

    All yours Gus.

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    January 18, 2012 at 8:46 am

    #1435311

  • RE: Count Function

    jennigirl (1/18/2012)

    I was able to get the query results I need, but I am looking to now present the results as the total count of trouble tickets assigned to each...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    January 18, 2012 at 8:38 am

    #1435300

  • RE: Help with Counts

    bicky1980 (1/11/2012)

    ...These are just the basic counts, I will need to then run these incoporating the where clause for various variables. If someone could advise of the best way...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    January 18, 2012 at 8:33 am

    #1435299

Viewing 15 posts - 556 through 570 (of 1,228 total)