Forum Replies Created

Viewing 15 posts - 961 through 975 (of 1,228 total)

  • RE: Question about "coalesce"

    I'd join table 2 twice, once on ID1 on both sides, and again on ID2 on both sides, then test for match in the output. Often, but not always, this...

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

    April 15, 2011 at 12:36 pm

    #1312302

  • RE: Are the posted questions getting worse?

    Craig Farrell (4/14/2011)

    Alright, there's any number of things to take my article apart for, half of it's an opinion... but there's vs. there are?

    I'm going to assume I'm just too...

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

    April 14, 2011 at 6:14 am

    #1311535

  • RE: The Job Posting - Do I really have to be the SQL God?

    Thanks Craig. This really opened my eyes to the BS in some of the posts I've been thinking about the last few days. Well written, great content. Job done.

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

    April 14, 2011 at 6:06 am

    #1311527

  • RE: Who's afraid of Gila Monsters?

    mtillman-921105 (4/13/2011)

    ChrisM@home (4/13/2011)

    mtillman-921105 (4/13/2011)

    mtillman-921105 (4/13/2011)

    Gila Monsters - the critters, not Gail, have a strange defense. Rather than a venom per se, their mouths are so full of bacteria and...

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

    April 14, 2011 at 12:03 am

    #1311429

  • RE: Question about "coalesce"

    ichiyo85 (4/13/2011)

    ChrisM@home: Good question! Would you have any suggestions? That's actually one that I don't know what to do...

    SQL Server - and the community who use it - are familiar...

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

    April 13, 2011 at 11:55 pm

    #1311428

  • RE: Who's afraid of Gila Monsters?

    mtillman-921105 (4/13/2011)

    mtillman-921105 (4/13/2011)

    Gila Monsters - the critters, not Gail, have a strange defense. Rather than a venom per se, their mouths are so full of bacteria and basically nasty...

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

    April 13, 2011 at 2:56 pm

    #1311345

  • RE: Which will execute first DISTINCT or TOP, if used in one query.

    Grant Fritchey (4/13/2011)

    ...

    You're still seeing two operations, right? If it's showing two operations, at least based on what I've learned, it's performing two operations...

    I'll live with that. Thanks Grant.

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

    April 13, 2011 at 2:02 pm

    #1311304

  • RE: Question about "coalesce"

    ichiyo85 (4/12/2011)

    "Unassigned" is just a name (nvarchar) that I gave to those cells that don't have values because I didn't want to leave them as NULL. Would it create any...

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

    April 13, 2011 at 2:00 pm

    #1311299

  • RE: Who's afraid of Gila Monsters?

    Grant Fritchey (4/13/2011)

    ChrisM@home (4/13/2011)

    CirquedeSQLeil (4/13/2011)

    Grant Fritchey (4/13/2011)

    Teh Gila Monster has teh big scares on me and makes me afeared fer me woefully inadequate sexual equipment.

    *cough*

    That should help.

    Don't you have 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]

    April 13, 2011 at 1:53 pm

    #1311294

  • RE: Which will execute first DISTINCT or TOP, if used in one query.

    Grant Fritchey (4/13/2011)

    ChrisM@home (4/13/2011)

    varun.dubey29 (4/13/2011)

    That is what the expected behavior I am expecting but in the execution plan it show that Distinct block returns fewer records than the 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]

    April 13, 2011 at 11:59 am

    #1311224

  • RE: Who's afraid of Gila Monsters?

    CirquedeSQLeil (4/13/2011)

    Grant Fritchey (4/13/2011)

    Teh Gila Monster has teh big scares on me and makes me afeared fer me woefully inadequate sexual equipment.

    *cough*

    That should help.

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

    April 13, 2011 at 11:22 am

    #1311201

  • RE: Which will execute first DISTINCT or TOP, if used in one query.

    varun.dubey29 (4/13/2011)

    That is what the expected behavior I am expecting but in the execution plan it show that Distinct block returns fewer records than the one in the table(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]

    April 13, 2011 at 4:17 am

    #1310907

  • RE: Who's afraid of Gila Monsters?

    If they are provoked into an attack, then they bite swiftly and hard, chewing the venom into the punctured, ravaged flesh of their tormentor, releasing only when the shocked victim...

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

    April 13, 2011 at 3:54 am

    #1310893

  • RE: Which will execute first DISTINCT or TOP, if used in one query.

    varun.dubey29 (4/13/2011)

    Hi All,

    I am using DISTINCT and TOP in same query as :

    SELECT DISTINCT TOP 100 ValidationDate FROM ValidatorDetails.

    ValidatorDetails table contains 2000 records.

    While looking at the execution plan, I found...

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

    April 13, 2011 at 3:42 am

    #1310889

  • RE: Delete with in case statement

    You don't need a cursor.

    Run this and check that the output represents the rows you want to delete:

    SELECT pmt.*, '#', pt.*, '#', p.*

    FROM posriskmatrix_testing pmt

    INNER JOIN pos_testing pt

    ON pt.idinst...

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

    April 13, 2011 at 1:32 am

    #1310836

Viewing 15 posts - 961 through 975 (of 1,228 total)