Forum Replies Created

Viewing 15 posts - 54,451 through 54,465 (of 59,089 total)

  • RE: Unstring text field?

    Bob Bridges (10/23/2007)

    I've got a problem that I can't figure out... I'm using the following as suggested to get the data to the right of the delimiter...

    (SELECT STUFF(GL_SWT,1,CHARINDEX('.', @col+'.'),'')

    It works...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 23, 2007 at 11:17 pm

    #744756

  • RE: Pivot Table Help Needed

    Sandy (10/23/2007)

    Hey Jason Tontz,

    In SQL 2005, you can use this Query.

    Hmmm... I wonder how Pivot in 2k5 would do against these simple 3 value pivots on a million rows? ...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 23, 2007 at 7:46 am

    #744532

  • RE: Adding workdays

    Yep... mine definetly fails for different languages... that's why I said you need to modify it for other languages. 😀

    Ken's DATEFIRST solution would fix that.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 23, 2007 at 7:40 am

    #744529

  • RE: Pivot Table Help Needed

    mrpolecat (10/23/2007)

    Just for S&G I removed your index completely and it didn't change performance time. Still 20 seconds. Here is the table I am using to test with...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 23, 2007 at 7:29 am

    #744517

  • RE: Pivot Table Help Needed

    rog pike (10/23/2007)

    RAC will never be amongst the fastest solutions. It is a simple tradoff, performance for functionality. RAC does not build a single SELECT statement to execute against a...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 23, 2007 at 7:15 am

    #744505

  • RE: Pivot Table Help Needed

    mrpolecat (10/23/2007)

    Peter Larsson (10/23/2007)

    I also lack the oppurtunity to call the SP twice in a row.

    I get an error "index already exists".

    I thnk it would make sense to move the...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 23, 2007 at 7:10 am

    #744499

  • RE: Pivot Table Help Needed

    Peter Larsson (10/23/2007)

    I also lack the oppurtunity to call the SP twice in a row.

    I get an error "index already exists".

    I'll check it out, Peter... thanks for the feedback.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 23, 2007 at 7:07 am

    #744495

  • RE: Pivot Table Help Needed

    Sandy (10/23/2007)

    Hey Jeff :),

    Great Standard of Code,

    I really feel its the way need to be done.

    but i have a small issue here,

    when i am trying to copy your code...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 23, 2007 at 7:03 am

    #744490

  • RE: Pivot Table Help Needed

    Peter Larsson (10/23/2007)

    Jeff, excellent code but I think you should start using QUOTENAME function for those having brackets, spaces or even single quotes in their table/column names.

    Yep... that would work,...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 23, 2007 at 7:03 am

    #744488

  • RE: Pivot Table Help Needed

    Fixed that... thanks for the observation... I always hate coverting working code into instructional code... I mess it up almost every time :hehe:

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 23, 2007 at 12:08 am

    #744326

  • RE: Saving binay data to disk via TSQL???

    Now you know why I don't let images and other blobs into may databases... too much of a hassle. I just store the names of files in the database...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 22, 2007 at 11:56 pm

    #744324

  • RE: System Performance - High CPU utilization--> SQLSRV.exe

    I know... I'm a sick man... I usually have a primary key and an alternate key... except for a relatively static state or country reference table, I don't like natural...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 22, 2007 at 11:39 pm

    #744323

  • RE: Pivot Table Help Needed

    If making RAC open source would stop your spamming, I'd be happy about that. 😛 And, your insults are a great way to drum up business :w00t:

    Just curious... how...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 22, 2007 at 11:22 pm

    #744320

  • RE: best way to find nulls? where [MyColumn] is null

    WHERE = NULL will not work unless you make a pretty uncommon (some consider it "dangerous") change to the ANSI NULL settings of the server. NULL is not "nothing"...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 22, 2007 at 9:58 pm

    #744312

  • RE: Conversion failed when converting datetime from character string.

    Look again... you're not getting what you think you're getting... run this small demo to see why...

    [font="Courier New"]DECLARE @Params VARCHAR(100)

    SET @Params = 'abcdefghij[ImportDate=12345678901234567890'

    SELECT SUBSTRING(@Params,PATINDEX('%[ImportDate=%', @Params)+13,19)[/font]

    ...did you...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 22, 2007 at 9:50 pm

    #744310

Viewing 15 posts - 54,451 through 54,465 (of 59,089 total)