Forum Replies Created

Viewing 15 posts - 54,421 through 54,435 (of 59,072 total)

  • RE: how to remove numbers from strings?

    Heh... dunno about anyone else, but as stated in my last... I'm just testing for duration comparisons of simple parallel methods, Ken... what are you going on about?

    --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 24, 2007 at 7:59 pm

    #745183

  • RE: 10/22

    I'm not so worried about me reading into such questions... I'm more worried that someone will take the answer as the gospel and mess up their data when they actually...

    --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 24, 2007 at 7:41 pm

    #745180

  • RE: TSQL query with stored procedure

    By default, SQL Server is not case senstive... you would have had to setup case sensitity when you setup the server or made a change to the who server after...

    --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 24, 2007 at 7:35 pm

    #745179

  • RE: returning balance value on TSQL

    Jeff your method is equisite as usual

    Thank for the nice compliment, Adam...:blush:

    Hopefully, Luissantos doesn't have 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 24, 2007 at 7:22 pm

    #745178

  • RE: INSERT A Hyphen

    You bet... 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 24, 2007 at 7:13 pm

    #745177

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

    Heh... I like the "downtown" explanation better.

    Light on = True... Light off = False... NULL = who the hell stole my lamp 😛

    --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 24, 2007 at 7:11 pm

    #745176

  • RE: Pivot Table Help Needed

    Heh... good... not my eyes... just time of day. Thanks, Matt.

    --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 24, 2007 at 9:27 am

    #745014

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

    Ah... got it... Looked more like VBS. Not sure why folks don't just write real code... doesn't take any longer 😛

    DECLARE @A INT --Defaults to NULL on...

    --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 24, 2007 at 9:13 am

    #745006

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

    rockzcm (10/24/2007)

    I agree.

    Null is an very interesting data type.

    a=null

    b=null

    if a=b then 'Yes'

    Else

    'No'

    You will expect to get No since you cannot compare two null values.

    Even more interesting... 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 24, 2007 at 8:44 am

    #744989

  • RE: Adding workdays

    Sergiy (10/22/2007)

    I said - I could not test.

    There was a typo in the formula.

    Also I corrected small logical error in the code:

    [Code]

    IF OBJECT_ID('dbo.fnAddWeekdays_Sergiy','fn') IS NOT NULL

    DROP FUNCTION dbo.fnAddWeekdays_Sergiy

    GO

    CREATE FUNCTION dbo.fnAddWeekdays_Sergiy...

    --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 24, 2007 at 1:45 am

    #744800

  • RE: Pivot Table Help Needed

    Peter Larsson (10/24/2007)

    Matt, excellent testing.

    BUT... I am missing data from SQL Profiler regarding CPU/DURATION/READS and WRITES for the different methods used.

    When I started out with SQL Server 2005 and PIVOT...

    --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 24, 2007 at 1:30 am

    #744793

  • RE: Pivot Table Help Needed

    VAIYDEYANATHAN.V.S (10/23/2007)

    Sometimes it is necessary to rotate results so that columns are presented horizontally and rows are presented vertically. This is known as creating a PivotTable®, creating a cross-tab report,...

    --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 24, 2007 at 1:10 am

    #744789

  • RE: Pivot Table Help Needed

    rog pike (10/23/2007)

    (This is not directed at anyone in particular. At most it

    rises to the level of a shot across the bow of a ship

    whose course needs dire correction).

    Exactly what...

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

    #744765

  • 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

Viewing 15 posts - 54,421 through 54,435 (of 59,072 total)