Forum Replies Created

Viewing 15 posts - 44,611 through 44,625 (of 59,101 total)

  • RE: Select distinct row on SQL 2000. Please help me!

    Ahh... got it. Thanks. Glad you were able to get them over the bad question. You could, however, use dynamic SQL to create a cross-tab should 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)

    March 14, 2009 at 2:37 pm

    #959793

  • RE: t-sql dates

    Bob Hovious (3/14/2009)

    Jeff, two things.

    1. Some code is missing from your first example. But I presume you were going to cross join syscolumns to itself. ...

    --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)

    March 14, 2009 at 2:31 pm

    #959791

  • RE: T-Sql rant

    BWAA-HAA!!! The real irony you speak of is that it obviously wasn't read by those that needed it the most! 😀

    --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)

    March 14, 2009 at 2:22 pm

    #959790

  • RE: Small server - any point in 64bit?

    Paul Hutchings (3/14/2009)

    the upgrade is mainly to get current vs. because our performance requirements/environment has changed.

    What I've found in the past is that such upgrades are expensive and are usually...

    --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)

    March 14, 2009 at 1:36 pm

    #959784

  • RE: Update query is killing me..

    Heh... the first step towards troubleshooting any code is to make it readable... when I do that to your code example, a certain problem with the code sticks out like...

    --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)

    March 14, 2009 at 1:16 pm

    #959781

  • RE: T-Sql rant

    foxjazz (3/13/2009)

    select name from mynametable where changedate > @yesterday

    fetch from @sel into @name

    while (@@fetch_status = 0)

    begin

    insert into nameother (name,changeddate) values (@name,getdate())

    end

    Do this without a cursor!

    Heh... rant complete... regard all further...

    --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)

    March 14, 2009 at 12:48 pm

    #959773

  • RE: T-Sql rant

    foxjazz (3/14/2009)

    Not having the ability to use non-cursored rowbased loops is a big downfall.

    There is a way to do non-cursored row-based loops in T-SQL... the technique is called "pseudo-cursors"...

    --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)

    March 14, 2009 at 12:29 pm

    #959772

  • RE: T-Sql rant

    foxjazz (3/14/2009)

    Ok set this baby... Real world.

    I have a table catagory fields are description, catID, typeID. parentID

    another tables queryed with (make, model, yr, engine).

    in the category table makes are typeid...

    --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)

    March 14, 2009 at 12:23 pm

    #959769

  • RE: t-sql dates

    Just thought I run this past you guys...

    On the subject of generating two years of test data... there's no need for RBAR. The following will run in about 3...

    --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)

    March 14, 2009 at 12:14 pm

    #959768

  • RE: t-sql dates

    Rob Fisk (3/13/2009)

    OK, so your total cost is 6-8 times faster than mine.

    Tally table example would be great. PM me since we have already crowded this topic somewhat.

    Thought I'd...

    --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)

    March 14, 2009 at 11:14 am

    #959755

  • RE: String Manipulation

    Goldie Graber (3/13/2009)

    I have received a requirement to write a trigger that accepts a string and then performs the following actions.

    1.Remove Script tags and contents

    2.Replace all HTML tags with spaces.

    3.Replace...

    --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)

    March 14, 2009 at 11:08 am

    #959753

  • RE: time difference computation

    thomyes (3/14/2009)

    I got the above msg when i tried to run the queries offered as solutions (to my time difference calculation prob. )here .

    It simply means that you have data...

    --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)

    March 14, 2009 at 10:59 am

    #959749

  • RE: slow running query/queries

    Such slowness is normally caused by a mistake somewhere in the query... formulas around columns in the WHERE clause will prevent good use of indexes... misunderstanding of the data may...

    --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)

    March 14, 2009 at 10:49 am

    #959741

  • RE: Recursive Join Problem

    Bob Hovious (3/14/2009)

    my requirement is that i have get the details about the parentid's along with the recursive data' in a single join

    Test question?

    I've been taking buisness requirements for years,...

    --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)

    March 14, 2009 at 10:42 am

    #959740

  • RE: How to import data from multiple CSV files into the same table

    Ramesh (3/14/2009)

    See this article on Looping, Importing and Archiving files in DTS Packages using ActiveX Script

    Just do 3 simple bulk inserts. It's also one of the fastest ways to...

    --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)

    March 14, 2009 at 10:37 am

    #959738

Viewing 15 posts - 44,611 through 44,625 (of 59,101 total)