Forum Replies Created

Viewing 15 posts - 14,521 through 14,535 (of 14,953 total)

  • RE: Replace non numeric characters in string

    For my next test, to get rid of some of the RBAR (though not eliminating it completely), I added an ID column to the table, and then ran:

    ;with

    CTE1 (ID,...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

    March 19, 2008 at 11:56 am

    #791615

  • RE: Replace non numeric characters in string

    (Had to split this post in half to avoid an error on the boards. Not sure why.)

    Results:

    ===================================================

    Proc 1 Run 1

    ===================================================

    SQL Server parse and compile time:

    CPU...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

    March 19, 2008 at 11:51 am

    #791609

  • RE: Replace non numeric characters in string

    Jeff Moden (3/18/2008)

    Sorry Gus... I actually didn't mean it that way (better)... I just meant it's different and you don't need the CTE if you don't want it. They...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

    March 19, 2008 at 11:49 am

    #791608

  • RE: Changing Career Gears

    I have a test box. Actually, have one at work and one at home. Trust me, I blow them up regularly. Ended up with a test of...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

    March 19, 2008 at 7:37 am

    #791436

  • RE: Problem in Query

    Glad you got it working.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

    March 18, 2008 at 1:59 pm

    #791112

  • RE: Basic Query Taking Too Long

    praseodymiumm (3/18/2008)

    Thank GSquared! I really appreciate your help.

    If I could ask another question?

    These queries will be used as data sources to build OLAP cubes (Cognos Transformer). Depending on which...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

    March 18, 2008 at 1:57 pm

    #791109

  • RE: Common Table Expressions

    srienstr (3/18/2008)

    69.5% of the total batch cost for the derived table method according to the execution plan, but only 31.8% of the runtime (according to the getdate() queries I inserted...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

    March 18, 2008 at 1:48 pm

    #791104

  • RE: Common Table Expressions

    jdoconsulting (3/18/2008)

    Does anyone have a good example of using a CTE to rollup assembly costs in a nested Bill of Materials? It seems to me that this should be done...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

    March 18, 2008 at 1:42 pm

    #791098

  • RE: Common Table Expressions

    Tao:

    The clarity thing is totally a personal preference. To me, being able to look at the query at the end, especially in things like complex updates, and have that...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

    March 18, 2008 at 8:32 am

    #790861

  • RE: COPYING TABLE STRUCTURE

    Adam Haines (3/17/2008)

    Actually you can click on Tool --> --> options --> scripting. From here you can set the default to script does not exists, script indexes, foreign keys...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

    March 18, 2008 at 8:16 am

    #790847

  • RE: Changing Career Gears

    For me, the certs are going to be more of a means of filling in the (huge) gaps in my knowledge.

    I'm totally self-trained on this, and it's mainly been by...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

    March 18, 2008 at 8:13 am

    #790845

  • RE: Replace non numeric characters in string

    Thanks Jeff. That's definitely better. (As mentioned, mine was thrown together and tested against one case.)

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

    March 18, 2008 at 8:01 am

    #790831

  • RE: Common Table Expressions

    paulsasik (3/18/2008)

    The query provided by Tao is fine and was the first solution i thought of when i read the example problem. However, the CTE example will effortlessly resolve the...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

    March 18, 2008 at 7:41 am

    #790814

  • RE: Common Table Expressions

    Tao Klerks (3/18/2008)

    SELECT TOP 1 dept_id, n

    FROM (

    SELECT dept_id, count(*) AS n

    FROM employee

    GROUP BY dept_id

    )...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

    March 18, 2008 at 7:37 am

    #790809

  • RE: Common Table Expressions

    Tao Klerks (3/18/2008)

    ...My instinct would be: Try to rewrite your statement to use joins and derived tables rather than subqueries, before moving to CTEs as a way of simplifying your...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

    March 18, 2008 at 7:32 am

    #790803

Viewing 15 posts - 14,521 through 14,535 (of 14,953 total)