Forum Replies Created

Viewing 15 posts - 241 through 255 (of 1,228 total)

  • RE: Using OVER Clause to instead of multiple selects

    You're welcome Terry. It's always good to see the OP figure it out by themselves - nice 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]

    February 9, 2014 at 9:36 am

    #1687373

  • RE: Using OVER Clause to instead of multiple selects

    You've got a little tangled up in the description! Try these two, I can't tell which one should work for you. The first seems to kinda fit the description better,...

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

    February 8, 2014 at 10:40 am

    #1687331

  • RE: Need Query

    That's great, thanks. What else can you tell us about your update?

    Are you only updating country if it's null in the target table? What if it is already populated?

    You're...

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

    February 8, 2014 at 8:05 am

    #1687324

  • RE: NPER Function from Excel

    That formula appears to be incorrect. Here's Microsoft's:

    SELECT NPER = LOG10((@PMT*(1+@rate*@type)-@FV*@rate)/(@PMT*(1+@rate*@type)+@PV*@rate))/ LOG10(1+@rate)

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

    February 8, 2014 at 7:33 am

    #1687318

  • RE: Need Query

    Please post the actual execution plan as a .sqlplan file. If you're not sure how to do this, you can find instructions in this article by Gail Shaw[/url].

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

    February 8, 2014 at 5:29 am

    #1687308

  • RE: I need to write a query using a join

    ripper_ol_boy (2/7/2014)

    Hey Chris,

    Could you explain the Select t1.*-- (I'm assuming it's some form of wildcard), but I've never used that before, and the only source I have for testing...

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

    February 7, 2014 at 10:12 am

    #1687133

  • RE: Testing the new "This worked" functionality.

    SQLRNNR (2/6/2014)

    ChrisM@home (2/6/2014)

    SQLRNNR (2/6/2014)

    ChrisM@home (2/6/2014)

    This "page" is all white.

    It'll be allwhite on the night.

    This page for me is half white half green.:alien:

    An aerogel frog. How original! I want one!

    Interesting...

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

    February 6, 2014 at 3:50 pm

    #1686846

  • RE: Testing the new "This worked" functionality.

    SQLRNNR (2/6/2014)

    ChrisM@home (2/6/2014)

    This "page" is all white.

    It'll be allwhite on the night.

    This page for me is half white half green.:alien:

    An aerogel frog. How original! I want one!

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

    February 6, 2014 at 3:37 pm

    #1686841

  • RE: Testing the new "This worked" functionality.

    This "page" is all white.

    It'll be allwhite on the night.

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

    February 6, 2014 at 3:25 pm

    #1686836

  • RE: Testing the new "This worked" functionality.

    Luis Cazares (2/6/2014)

    Could you mark all of them?

    This could be called as the green thread 😀

    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]

    February 6, 2014 at 2:56 pm

    #1686818

  • RE: Are the posted questions getting worse?

    A good friend used to regularly have a little moan about how little sex he was having with his girlfriend. "Once a fortnight - it's doing my head in!" Then...

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

    February 6, 2014 at 2:20 pm

    #1686778

  • RE: Different Index - More number of physical reads

    Hot cache and you are still getting physical reads after running your query multiple times...How many rows in your 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]

    February 6, 2014 at 1:51 pm

    #1686764

  • RE: Different Index - More number of physical reads

    curious_sqldba (2/6/2014)

    ChrisM@home (2/6/2014)

    curious_sqldba (2/6/2014)

    ChrisM@home (2/6/2014)

    How are you choosing index 2 over index1?

    Dropping index 1 and creating Index 2.

    Why would you choose index 2 over index1?

    I am not, i just asked...

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

    February 6, 2014 at 1:29 pm

    #1686755

  • RE: Different Index - More number of physical reads

    curious_sqldba (2/6/2014)

    ChrisM@home (2/6/2014)

    How are you choosing index 2 over index1?

    Dropping index 1 and creating Index 2.

    Why would you choose index 2 over index1?

    I am not, i just asked a question...

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

    February 6, 2014 at 1:23 pm

    #1686751

  • RE: Selecting rows in a table.. not so simple!

    Sean Lange (2/6/2014)

    marcipesa (2/6/2014)

    something like this?:

    http://stackoverflow.com/questions/17604893/how-can-i-match-the-sum-of-a-subset-of-items-to-a-target-number

    Yeah something like that. Notice the looping, this is a performance killer in sql. You have the added complexity of a number of value sets...

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

    February 6, 2014 at 1:16 pm

    #1686746

Viewing 15 posts - 241 through 255 (of 1,228 total)