Forum Replies Created

Viewing 15 posts - 58,516 through 58,530 (of 59,091 total)

  • RE: Sort By Date??

    GM beat me to it but using his test, I came up with the same correct results all 3 times...

    SortOrder,Letter

    0,e

    0,b

    1,a

    1,f

    1,c

    2,d

    2,g

    Ryan, Yep, I tried it and you are correct (I forgot...

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

    January 4, 2006 at 7:12 am

    #612590

  • RE: SQL with Search Score

    As the article warns, this method makes use of a correlated subquery that forms a triangular join which is half a cross join.  It will crush any hopes of performance...

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

    January 3, 2006 at 8:35 pm

    #612507

  • RE: SQL with Search Score

    You do not need to enable full text features to use SOUNDEX or DIFFERENCE...

    DECLARE @Str1 VARCHAR(100)

    DECLARE @Str2 VARCHAR(100)

    SET @Str1 = '129 Green Ave'

    SET @Str2 = 'Green...

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

    January 3, 2006 at 8:24 pm

    #612506

  • RE: Sort By Date??

    If tl.Date is a DateTime column to begin with, you don't need to do any of that.... the Order By tl.Date will work correctly even though you've Cast it in...

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

    January 3, 2006 at 8:03 pm

    #612503

  • RE: Result from 2 tables with no link

    I'm still curious... why did you want to join two tables that have nothing in common to join 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)

    January 3, 2006 at 7:58 pm

    #612502

  • RE: Unload to txt file?

    That's what I thought... thanks for the feedback, Trigger.

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

    January 2, 2006 at 7:43 pm

    #612337

  • RE: Create Listing of Files

    Just a reminder, folks... xp_CmdShell requires SA privs or a proxy login that has SA privs.

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

    January 2, 2006 at 3:25 pm

    #612327

  • RE: Using the Forumla option of the gui when creating a TABLE

    Pat,

    Basically, any legal expression may be used so long as it does not refer to another table.  Cast and Case may be used.  SELECT may not because it's a "clause"...

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

    December 30, 2005 at 1:02 pm

    #612211

  • RE: Why this sql is valid

    Nope... it's not... SET ls_action=0 will fail in the absence of other code.  You either have to declare ls_action as variable (don't forget to add the @ sign) or you have...

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

    December 30, 2005 at 12:37 pm

    #612208

  • RE: Syntax for querying a timestamp column

    Daniel,

    The other thing you may not be aware of is that if you update ANY column in the table that has a timestamp column, the TimeStamp will change.  I think...

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

    December 30, 2005 at 12:27 pm

    #612207

  • RE: use cursor or what?

    Ok, thanks... you sure you wanted the duplication in the #QueryTable?  Could get pretty nasty if you have lots of 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)

    December 30, 2005 at 12:05 pm

    #612205

  • RE: Unload to txt file?

    Steve and Ken...

    Yup, I knew that... I just thought that since Trigger recommended it as a T_SQL command, there might be some neat trick he was using to use it...

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

    December 30, 2005 at 12:02 pm

    #612203

  • RE: Dropping and Re-creating Indexes

    Yup, your method works just fine (but what a pain with all of those indexes).  And, deleting the "dupes" probably wouldn't be any faster because of the indexes.

    And, to answer...

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

    December 29, 2005 at 10:30 pm

    #612083

  • RE: Unload to txt file?

    Trigger,

    How do you use BCP from T-SQL without using xp_CmdShell which is normally off limits to all but those members of the SA role? 

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

    December 29, 2005 at 10:15 pm

    #612082

  • RE: String Question

    Thgamble1,

    Carl has the correct answer here... did it work for you or do you still have a question?

     

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

    December 29, 2005 at 10:07 pm

    #612081

Viewing 15 posts - 58,516 through 58,530 (of 59,091 total)