Forum Replies Created

Viewing 15 posts - 481 through 495 (of 1,228 total)

  • RE: Grand total help

    djmason_2001 (10/9/2012)

    Hi

    thank you for your response

    In your last part of the query i dont get what this is meant to do

    I understand you want me to select...

    [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 9, 2012 at 3:20 am

    #1547090

  • RE: A severe error occurred on the current command

    Microsoft has a ton of relevant support articles:

    http://support.microsoft.com/search/default.aspx?query=a+severe+error+occurred&catalog=LCID%3D2057&mode=r

    Of those, this looks promising:

    http://support.microsoft.com/kb/948525

    Scanning through this lot, here's what I'd suggest:

    List the version / SP / CU level etc of the instance....

    [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 9, 2012 at 2:47 am

    #1547071

  • RE: Merging Duplicate Records

    chris.ross 34852 (10/9/2012)

    Hello! I have a rather complex data integration challenge I'd love some input on. The scenario is a a system of record that has allowed for multiple duplicate...

    [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 9, 2012 at 1:55 am

    #1547054

  • RE: Grand total help

    djmason_2001 (10/9/2012)

    hey

    Has anyone else got any ideas on how to solve this issue ?

    CTE's are probably easiest for this, the two queries are I think may be too dissimilar...

    [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 9, 2012 at 1:46 am

    #1547050

  • RE: Seeking alternate method to CTE

    What are the indexes on thoee tables, specifically mytree? Try running the results of the rCTE into a #temp table and joining the other tables to it.

    [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 4, 2012 at 10:37 am

    #1545677

  • RE: Multipe letters into one

    Jeff Moden (10/1/2012)

    Actually, I don't recommend handling this at all. It will break properly spelled names.

    +1

    [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 1, 2012 at 1:01 pm

    #1544098

  • RE: Archiving...INSERT & DELETE

    oscarooko (9/11/2012)

    Lynn Pettis (9/11/2012)

    ChrisM@Work (9/11/2012)

    Lynn Pettis (9/11/2012)

    ChrisM@Work (9/11/2012)

    oscarooko (9/11/2012)

    It actually took me 47 minute to delete 13 684 records in batches of 100. I am there's got to be 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]

    September 11, 2012 at 2:48 pm

    #1536497

  • RE: Looping through table

    jadelola (9/10/2012)

    Thanks 🙂

    How do I calculate the AmountLeftWith field? I wrote it hardcoded now in the example but that is what the acutal result should be.

    Thanks

    I've no idea. Using your...

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

    September 10, 2012 at 1:03 pm

    #1535885

  • RE: Looping through table

    jadelola (9/10/2012)

    I hope I got it right this time 🙂

    Here's your DDL and DML adjusted so it doesn't throw an error and doesn't implicitly convert numbers as text into decimal....

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

    September 10, 2012 at 7:03 am

    #1535661

  • RE: Looping through table

    jadelola (9/10/2012)

    Hi,

    It's not 250.00 but 250.000.

    Your figures are not in a consistent format, you are interchanging '.' and ',' as the thousands separator. It's making this excercise confusing. Can I...

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

    September 10, 2012 at 6:41 am

    #1535651

  • RE: Looping through table

    Customer 2 has 1300.00, which exceeds 250.00. I can't make any sense of your math.

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

    September 10, 2012 at 6:05 am

    #1535636

  • RE: Are all columns really included in the clustered index?

    Edit: sorry, wrong class.

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

    August 28, 2012 at 10:54 am

    #1530961

  • RE: Record linkage advice required– Long read (YOU HAVE BEEN WARNED!)

    Here's a method I've used with some success in the past. I've changed a few data elements in your sample set, so that the dupes no longer have the same...

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

    July 30, 2012 at 2:45 pm

    #1519423

  • RE: Get running total in the following query

    XMLSQLNinja (7/25/2012)

    Gosh, that's quite confrontational.

    My sincere apologies if I came off as confrontational; that was not my intent. ...

    No offence taken Alan, and thanks for encouraging these tests...

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

    July 25, 2012 at 3:38 pm

    #1517654

  • RE: Query help to update with next records

    Without an ORDER BY, TOP is meaningless:

    SELECT

    t1.col1,

    col2 = ISNULL(t1.col2, x.col2)

    FROM @T t1

    OUTER APPLY (

    SELECT TOP 1

    t2.col2

    FROM @T t2

    WHERE t2.col1 > t1.col1

    AND t2.col2 IS NOT NULL...

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

    July 22, 2012 at 3:28 am

    #1515950

Viewing 15 posts - 481 through 495 (of 1,228 total)