Forum Replies Created

Viewing 15 posts - 5,836 through 5,850 (of 10,144 total)

  • RE: T-SQL String Manipulation- Need help

    Cadavre (8/22/2012)

    ChrisM@Work (8/22/2012)

    SELECT

    Stringy,

    Stuffy = STUFF(STUFF(STUFF(Stringy,x3.startpos+1,x3.endpos-x3.startpos-1,'n'),x2.startpos+1,x2.endpos-x2.startpos-1,'n'),x1.startpos+1,x1.endpos-x1.startpos-1,'n')

    FROM (SELECT Stringy = 'A1(1).B22(10).C345(100)') d

    CROSS APPLY (SELECT startpos = CHARINDEX('(',Stringy,1), endpos = CHARINDEX(').',Stringy+'.',1)) x1

    CROSS APPLY (SELECT startpos = CHARINDEX('(',Stringy,x1.startpos+1), endpos = CHARINDEX(').',Stringy+'.',x1.endpos+1)) x2

    CROSS...

    August 22, 2012 at 8:49 am

    #1528687

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (8/22/2012)

    GilaMonster (8/22/2012)

    jcrawf02 (8/22/2012)

    GilaMonster (8/22/2012)

    BrainDonor (8/22/2012)

    GilaMonster (8/22/2012)

    Nitpicking I can take, this is getting well beyond that.

    I have to say Gail that it was a fascinating thread up to a...

    August 22, 2012 at 8:42 am

    #1528683

  • RE: T-SQL String Manipulation- Need help

    SELECT

    Stringy,

    Stuffy = STUFF(STUFF(STUFF(Stringy,x3.startpos+1,x3.endpos-x3.startpos-1,'n'),x2.startpos+1,x2.endpos-x2.startpos-1,'n'),x1.startpos+1,x1.endpos-x1.startpos-1,'n')

    FROM (SELECT Stringy = 'A1(1).B22(10).C345(100)') d

    CROSS APPLY (SELECT startpos = CHARINDEX('(',Stringy,1), endpos = CHARINDEX(').',Stringy+'.',1)) x1

    CROSS APPLY (SELECT startpos = CHARINDEX('(',Stringy,x1.startpos+1), endpos = CHARINDEX(').',Stringy+'.',x1.endpos+1)) x2

    CROSS APPLY (SELECT...

    August 22, 2012 at 7:58 am

    #1528644

  • RE: Update table based on column grouping

    DerbyNeal (8/22/2012)

    Thanks Luis & Dwaine for your help.

    Dwain - I Don't need to cater for that, as the table query is refreshed each day (It is a snap-shot query).

    It...

    August 22, 2012 at 7:01 am

    #1528600

  • RE: UPDATE when the values are the same

    SQL Kiwi (8/22/2012)

    ChrisM@Work (8/22/2012)

    Updating a clustered index key causes a delete/insert to the table and updates any non-clustered indexes to reflect the new key. And whatever else. That's a lot...

    August 22, 2012 at 5:45 am

    #1528565

  • RE: UPDATE when the values are the same

    SQL Kiwi (8/22/2012)

    ChrisM@Work (8/16/2012)

    It's interesting that in only the cheapest case has update to self been optimized out. Perhaps checking for change in a LOB column is more expensive than...

    August 22, 2012 at 4:59 am

    #1528544

  • RE: Are the posted questions getting worse?

    GilaMonster (8/22/2012)

    Yes, same one, and it's the thread with Paul involved.

    "But it's not the only target people could chase with the statement, would you agree?"

    Strange way to elicit a...

    August 22, 2012 at 4:05 am

    #1528540

  • RE: Are the posted questions getting worse?

    dwain.c (8/22/2012)

    ChrisM@Work (8/22/2012)

    dwain.c (8/22/2012)

    ChrisM@Work (8/22/2012)

    If this is the same individual as last time

    He who must not be named...

    Between wizards and Jedi, this board is always interesting and fun... 🙂

    Dwain,...

    August 22, 2012 at 2:40 am

    #1528504

  • RE: Need Create View Script for all tables

    Ankur Bajaj (8/22/2012)

    ... This is so as not to affect database performance for App users....

    Absolute nonsense. If you must do it, then don't do it for this reason.

    August 22, 2012 at 2:18 am

    #1528493

  • RE: Are the posted questions getting worse?

    dwain.c (8/22/2012)

    ChrisM@Work (8/22/2012)

    If this is the same individual as last time

    He who must not be named...

    Between wizards and Jedi, this board is always interesting and fun... 🙂

    Dwain, that monster...

    August 22, 2012 at 2:12 am

    #1528490

  • RE: Are the posted questions getting worse?

    GilaMonster (8/22/2012)

    Grrr. Why do some people want to nitpick holes in things I say and do it in a way that sounds very much like a personal attack?

    If this is...

    August 22, 2012 at 1:54 am

    #1528483

  • RE: Today's Random Word!

    SQLRNNR (8/21/2012)

    Warble

    Wobble

    August 22, 2012 at 1:41 am

    #1528477

  • RE: Will indexed view help this query?

    S_Kumar_S (8/21/2012)

    But the results of this and previous query doesn't match. Seems ordering on different column changed the results.

    The results will differ if any of the DIM... tables introduce more...

    August 21, 2012 at 9:41 am

    #1528203

  • RE: Improving query performance to detect first duplicate

    Sales 1 and 2 overlap on date range and have a common item & location.

    Same with 2 and 5. But 1 and 5 don't overlap: 1, 2 & 5 aren't...

    August 21, 2012 at 9:03 am

    #1528170

  • RE: Today's Random Word!

    Ray K (8/21/2012)

    ChrisM@Work (8/21/2012)

    rhythmk (8/20/2012)

    Cliff Jones (8/20/2012)

    Scott D. Jacobson (8/20/2012)

    SQLRNNR (8/20/2012)

    Ray K (8/20/2012)

    Manic Monday

    The Bangles

    Susanna Hoffs and Matthew Sweet.

    Ming Tea

    Green Tea

    Green Day

    Green Bay

    Bay City Rollers

    August 21, 2012 at 6:43 am

    #1528086

Viewing 15 posts - 5,836 through 5,850 (of 10,144 total)