Forum Replies Created

Viewing 15 posts - 406 through 420 (of 1,228 total)

  • RE: Searching Columns for Seperate Strings

    Eugene Elutin (10/18/2012)

    Duplicate post with "changed" requirements:

    http://www.sqlservercentral.com/Forums/Topic1374194-391-1.aspx

    I reckon the OP is having some difficulty simplifying the real problem. Here's a solution to the "new" requirements;

    ;WITH Mysample (Record_id, Col1, Col2, Col3,...

    [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]

    October 18, 2012 at 7:49 am

    #1550495

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (10/17/2012)

    It's a disgrace, a disgrace I say. Why do you want to know what I know I know? It's a disgrace, a disgrace I say.

    Young fella, do you...

    [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]

    October 18, 2012 at 12:08 am

    #1550302

  • RE: Converting Stored Procedures to SSIS packages

    Andy Hyslop (10/17/2012)

    Complex SSIS packages are more likely to increase maintenance cost than decrease it, because there are far more places to look for functionality, and more scope for introducing...

    [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]

    October 17, 2012 at 3:24 am

    #1549927

  • RE: End Date Issue

    You have two sequence columns in your table - do either of them have gaps? If one of them is guaranteed to have no gaps, then join the table to...

    [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]

    October 17, 2012 at 3:21 am

    #1549925

  • RE: Checking values in multiples columns

    CROSS APPLY VALUES[/url] was made for this;

    ;WITH Mysample (Record_id, Col1, Col2, Col3, Col4, Col5) AS (

    SELECT 101, 'A', 'A', 'B', 'A', 'A' UNION ALL

    SELECT 102, 'B', 'B', NULL, NULL, 'B'...

    [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]

    October 17, 2012 at 3:07 am

    #1549922

  • RE: Converting Stored Procedures to SSIS packages

    deepa lekshmi (10/16/2012)

    There are SPs that call another SP many times with different parameters(The parameters are hardcoded in the SP).

    There may be some scope for improvement here. That's...

    [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]

    October 17, 2012 at 2:50 am

    #1549914

  • RE: Converting Stored Procedures to SSIS packages

    deepa lekshmi (10/17/2012)

    Rob, We are asked to do that since the long procedures are not easy to manage. Also, wanted to improve the performance. I am not sure whether converting...

    [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]

    October 17, 2012 at 2:48 am

    #1549913

  • RE: How do I join tables, but select top 1 from 1-many tbl?

    Eric M Russell (10/15/2012)

    You can simulate the functional equivalent in SQL Server 2000 less gracefully like so:

    select C_RECID, H_RECID from

    (

    select C.RECID C_RECID, H.RECID H_RECID,

    (select count(*) from...

    [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]

    October 17, 2012 at 2:37 am

    #1549909

  • RE: time in query execution

    Duplicate post. Answers to http://www.sqlservercentral.com/Forums/FindPost1373217.aspx please.

    [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]

    October 16, 2012 at 8:05 am

    #1549587

  • RE: QUERY taking too much time in execution

    kapil_kk (10/16/2012)

    hey Chris,

    can you plz tell me why you placed this line -

    INNER JOIN (select fstate from WCDentalSQL_TOR..ZipCode GROUP BY fstate) d ON d.fstate = Z.fState

    I am not clear 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]

    October 16, 2012 at 7:51 am

    #1549570

  • RE: Avg count of cases per day

    Eugene Elutin (10/16/2012)

    ...

    So, TVF's one is faster than permanent table! Faster by the whole 33ms!

    And here I would agree with Joe (that doesn't happen to often ;-)): what about concurrent...

    [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]

    October 16, 2012 at 7:46 am

    #1549565

  • RE: QUERY taking too much time in execution

    kapil_kk (10/16/2012)

    bcoz cursor works on row-by-row basis taht why it takes long time to execute if there are execess rows in your table...

    Your cursor block is running slowly because you...

    [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]

    October 16, 2012 at 7:28 am

    #1549551

  • RE: QUERY taking too much time in execution

    vyas (10/16/2012)

    Avoid cursor and try use while..loop

    Why?

    [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]

    October 16, 2012 at 7:20 am

    #1549540

  • RE: Avg count of cases per day

    kwoznica (10/16/2012)

    ChrisM@home (10/16/2012)

    Does this help?

    Definately does. I was confused by the additional d and f in the inner and outer queries and thought they were needed for some reason in...

    [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]

    October 16, 2012 at 7:19 am

    #1549538

  • RE: Reset the Number by Column Value using ROW_NUMBER() OVER (PARTITION BY Field)

    Lowell (10/16/2012)

    patelmohamad (10/16/2012)

    Thanks Lowell for instant reply,

    This is my predication, not the actual data

    , actual data is differ from my Example

    in my data it gives me lot of no's 1,2,3.......n...

    [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]

    October 16, 2012 at 7:03 am

    #1549530

Viewing 15 posts - 406 through 420 (of 1,228 total)