Forum Replies Created

Viewing 15 posts - 1,036 through 1,050 (of 1,228 total)

  • RE: what laptop do you use?

    GilaMonster (7/21/2010)

    HP Pavillion Wide-screen 15.4. It's an entertainment notebook, which for me means pretty good specs without too high a price. Runs SQL well, plays movies, runs games, just about...

    [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 29, 2010 at 2:40 pm

    #1244430

  • RE: Pivot I guess

    Pavan as Craig says, please set up some sample data in the form of a CREATE TABLE statement followed by INSERT to populate your table with data. Include at least...

    [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 29, 2010 at 2:09 pm

    #1244412

  • RE: what laptop do you use?

    HP HDX 18

    P8400 Core 2 Duo, 4GB RAM, Vista Home Premium 64bit (runs SQL2k8 just fine).

    Full HD 18" wide aspect ratio screen

    2 x ST9250827AS disks

    BD burner (plays BD movies nicely).

    Fullsize...

    [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 29, 2010 at 12:35 pm

    #1244383

  • RE: temp table in view

    sravanb (10/28/2010)

    Hello All,

    Is it a good practice to use a temp tables in a view?

    How do we handle temp tables in views?

    Please explain in detail.

    Thank you,

    Sra1

    Others will provide a 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]

    October 28, 2010 at 1:23 pm

    #1243801

  • RE: Parent/Child relationship

    CELKO (10/28/2010)

    "I can resist anything but temptation" -- Mae West

    Commendable restraint, Joe.

    [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 28, 2010 at 12:48 pm

    #1243786

  • RE: Parent/Child relationship

    Chrissy321 (10/28/2010)

    Which brings me to this....

    SELECT

    CASE WHEN EXISTS

    (

    SELECT 1

    FROM Parent P

    INNER JOIN Child C

    ON MyTable.ParentID = P.ParentID

    INNER JOIN ChildCustom CC

    ON MyTable.ChildID = CC.ChildID

    WHERE...

    [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 28, 2010 at 12:47 pm

    #1243785

  • RE: Parent/Child relationship

    Isn't this:

    CASE WHEN EXISTS

    (

    SELECT 1

    FROM Parent P

    WHERE P.Parent_CD = Child.Parent_CD

    AND P.Parent_CD IN

    ( SELECT DISTINCT P.Parent_CD...

    [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 28, 2010 at 10:21 am

    #1243690

  • RE: using group by and count together.

    Hahaha that's too funny!

    I bet it's the same performance too.

    Ben, if you're interested and have the time, you could assess all three queries for performance using the simplest method:

    SET...

    [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 28, 2010 at 9:01 am

    #1243615

  • RE: using group by and count together.

    BenWard (10/28/2010)

    haha yes

    which is (I think) exactly the same as

    ;WITH cteSource(Data)

    AS (

    SELECT 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 28, 2010 at 5:39 am

    #1243458

  • RE: using group by and count together.

    BenWard (10/28/2010)

    thats brilliant thanks.

    I'm surprised there isnt an alternative version of count in sql server that returns the number of rows like a numrows() function or whatever.

    Thanks

    Like this version?

    SELECT COUNT(*)

    FROM...

    [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 28, 2010 at 5:12 am

    #1243452

  • RE: In Line Subquery versus Join query

    Jeff Moden (10/27/2010)

    ChrisM@home (10/27/2010)

    Run them both and look at the actual execution plans. You may be surprised to find they are the same or "trivially different" - maybe.

    Oh, be careful.......

    [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 27, 2010 at 11:34 am

    #1243102

  • RE: Really Simple - "Join" clarification

    drew.allen (10/26/2010)

    My issue with defining it as multiple tables is that you lose the fact that the order is important when you start introducing outer joins.

    You need 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]

    October 27, 2010 at 8:21 am

    #1242921

  • RE: insert if not exists, if it does insert into another table

    Brandie Tarvin (10/27/2010)

    Maina-456685, Could you provide sample data so Chris and I can verify solutions before we post them?

    Thanks Brandie. Unfortunately my eval version of 2k8 has just expired so...

    [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 27, 2010 at 8:12 am

    #1242912

  • RE: Hard coding leading zeros to Unique IDs

    mashikoo (10/27/2010)

    I'm trying to include leading zeros to unique IDs in my query

    Can you post the query? Also the DDL for one of the tables?

    [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 27, 2010 at 7:34 am

    #1242875

  • RE: In Line Subquery versus Join query

    Run them both and look at the actual execution plans. You may be surprised to find they are the same or "trivially different" - maybe.

    [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 27, 2010 at 7:31 am

    #1242870

Viewing 15 posts - 1,036 through 1,050 (of 1,228 total)