Forum Replies Created

Viewing 15 posts - 226 through 240 (of 1,228 total)

  • RE: yippee i passed!!

    Perry Whittle (2/21/2014)

    passed my Class II Civil Avaition Authority medical today 😀

    Will we have to call you Gloster now? 🙂 Well done Perry.

    [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 21, 2014 at 12:25 pm

    #1691265

  • RE: SQL Query

    Homework or competition? What have you tried so far?

    [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 21, 2014 at 1:00 am

    #1690999

  • RE: Am I taking crazy pills? Dispute over inner vs. outer join.

    SQLRNNR (2/14/2014)

    Sean Lange (2/14/2014)

    SQLRNNR (2/14/2014)

    I have seen that kluge query method work much faster and I have seen it be slower. It all depends. It would be well...

    [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 14, 2014 at 12:45 pm

    #1689188

  • RE: Am I taking crazy pills? Dispute over inner vs. outer join.

    Ask your designer about the performance implications of ISNULL around a join column - and research it yourself first if you're not already 100% sure.

    [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 14, 2014 at 12:36 pm

    #1689181

  • RE: I need to de-duplicate a large table (lots of full-row dups)

    Groundhog Day, Keith. He's seen this once or twice before 😉

    [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 11, 2014 at 12:43 pm

    #1688075

  • RE: Concatinating date and string

    Convert it to BIGINT.

    [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 11, 2014 at 11:51 am

    #1688058

  • RE: SQL Server Function: Cursor or Tally Table; which to use, HELP

    Lowell (2/11/2014)

    well i've only done one piece of it...adding the date;

    i have a simple macro i use to dump typical copy/paste data and turn it into a CTE, so coming...

    [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 11, 2014 at 10:35 am

    #1688014

  • RE: dense_rank

    Both functions will result in a sort unless a) the data coming into the operator is sorted same as the order by of the function and b) the query processor...

    [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 11, 2014 at 10:32 am

    #1688012

  • RE: INSERT INTO, EXCLUDING ONE COLUMN

    Use the OUTPUT clause on an UPDATE statement. OUTPUT was introduced in SQL Server 2005.

    [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 10, 2014 at 12:55 am

    #1687440

  • RE: Sending a Variable Number of Elements in a Parameter

    Recursive CTE's aside (I've done a little work with them), I think you are still missing the point - they're a coding shortcut. If you cannot consider your CTE 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]

    February 9, 2014 at 3:33 pm

    #1687399

  • RE: Getting the 'next' occurance of historic dates

    Here's a little test harness. If you can't figure it out from here, let us know:

    WITH

    Today AS (SELECT Today = '20120228' UNION ALL SELECT '20120229' UNION ALL SELECT CAST(GETDATE()...

    [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 3:21 pm

    #1687398

  • RE: Getting the 'next' occurance of historic dates

    This is straightforward using DATEDIFF and DATEADD. what do you want to do with a date which is exactly a year ago (or two years, or three)? Today one year...

    [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 2:46 pm

    #1687394

  • RE: need help with a query

    youresoshain (2/9/2014)

    So i ended up going with a union query that syncs grouped by carbon_copy_id and one without and it seems to be doing the job.

    Thanks guys for getting...

    [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 1:43 pm

    #1687391

  • RE: Sending a Variable Number of Elements in a Parameter

    Not sure what you mean Peter - a CTE is just a macro, a view on the fly. Can you construct your idea into pseudocode, it might make it easier...

    [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 11:26 am

    #1687388

  • RE: Sending a Variable Number of Elements in a Parameter

    Peter E. Kierstead (2/9/2014)

    One of my first attempts at splitting delimited data in a column used the XML shred method. Even on relatively small tables (by row count) the queries...

    [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:48 am

    #1687375

Viewing 15 posts - 226 through 240 (of 1,228 total)