Forum Replies Created

Viewing 15 posts - 1,006 through 1,020 (of 1,228 total)

  • RE: result problems in sql views

    The two queries in your first post are functionally identical and show an indirect relationship between bill_info and accounts_transaction. Whilst the joins between the two tables are known, the cardinality...

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

    December 5, 2010 at 7:10 am

    #1258814

  • RE: two insert statments takes long time to process

    dlam 18073 (11/21/2010)

    thx ppls to give me help!

    I did a test on two different sp (test with 3400 rows),

    one is my sp, processing time 46 sec

    another one from tommyh, processing...

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

    December 4, 2010 at 2:07 pm

    #1258778

  • RE: two insert statments takes long time to process

    ngreene (12/3/2010)

    Always try to use LEFT JOIN (or RIGHT) instead of NOT IN or NOT EXIST. LEFT JOIN is going to have faster performance.

    insert into tblClientList (clientNumber)

    SELECT a.clientNumber

    from tblOrder...

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

    December 4, 2010 at 2:02 pm

    #1258777

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (11/26/2010)

    da-zero (11/26/2010)

    Hmmm. I found a post of Celko where he says that he is the way he is online because he uses the "tear them down to build them...

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

    November 26, 2010 at 12:02 pm

    #1255866

  • RE: 1 column vs 2 columns (using integer and varchar)

    An entity-attribute-value system?

    Your original post asked how best to store a value which could be either an integer or a character value in one or more columns of a table....

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

    November 26, 2010 at 6:44 am

    #1255803

  • RE: 1 column vs 2 columns (using integer and varchar)

    michel.zdw (11/26/2010)

    hi

    i need to store a value that can be integer or string (depends on a key value)

    is it better to use 2 columns or to use 1 column (varchar)...

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

    November 26, 2010 at 3:14 am

    #1255761

  • RE: Big table 50MB containing just 1000 records ( a few small fields each record)

    Iulian -207023 (11/23/2010)

    Hello,

    I have a big table 50MB containing just 1000 records ( a few small fields each record).

    On indexes I have one primary key and one clustered index, 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]

    November 23, 2010 at 3:52 pm

    #1254808

  • RE: Calculate dates an individual lives in apartement each month

    stan-617410 (11/21/2010)

    Lutz,

    Thank you for your questions.

    There are two tables - Tenant and Buildings.

    The ID in Tenant = ID_U in Buildings.

    If a tentant returns they will have...

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

    November 23, 2010 at 2:38 pm

    #1254759

  • RE: transaction size limit

    <<We get the file full of INSERT UPDATE and DELETE>>

    Is this a transit file? If not, what is it? Can you post a few lines?

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

    November 23, 2010 at 2:11 pm

    #1254739

  • RE: Dynamic SQL issue

    In this particular case, the answer is straightforward:

    Before

    EXEC(@SQL)

    Put PRINT @sql

    and see what it returns 😉

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

    November 23, 2010 at 2:07 pm

    #1254737

  • RE: Using Case or If Else statements within joins

    Cheryl McLaughlin-385812 (11/23/2010)

    Both to ChrisM and Drew. I appreciate the feedback.

    To Drew:

    However, the correct name is not pulling up. The original code modified using everyone's input:

    SELECT glbank.check_num

    , glbank.ref_num

    , glbank.check_amt

    , glbank.check_date

    ,...

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

    November 23, 2010 at 1:34 pm

    #1254716

  • RE: Search part of string within part of string

    Didn't this work?

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

    November 23, 2010 at 12:55 pm

    #1254687

  • RE: Using Case or If Else statements within joins

    Cheryl - try both options (conditional join or two left joins) and compare performance, preferably on a live or scaled-up test db. Usually the two (and only two, it usually...

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

    November 23, 2010 at 12:27 pm

    #1254670

  • RE: cursor appropriate?

    MonsterRocks (11/22/2010)

    Chris.. the links in ur signature u want me to check out?

    @MonsterRocks - Sorry mate, got tied up, but Wayne jumped in with solution.

    @Wayne - cheers mate, sorted.

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

    November 22, 2010 at 12:28 pm

    #1253953

  • RE: Are the posted questions getting worse?

    bitbucket-25253 (11/20/2010)

    Stefan Krzywicki

    That's not really a clue so much as asking us to do math.

    Now did you know the year WWII ended (1945) or did you have to Google that?

    But...

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

    November 21, 2010 at 3:37 am

    #1253474

Viewing 15 posts - 1,006 through 1,020 (of 1,228 total)