Forum Replies Created

Viewing 15 posts - 24,361 through 24,375 (of 59,102 total)

  • RE: LIKE and NULLs

    thisisfutile (2/17/2014)

    Jeff Moden (2/16/2014)

    thisisfutile (2/14/2014)

    fsuoj (2/14/2014)

    Where is it documented that not using % assumes % at the end?

    The Insert "trims" the trailing spaces from the data.

    Not quite right. Trailing...

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

    February 17, 2014 at 9:42 pm

    #1689720

  • RE: LIKE and NULLs

    fsuoj (2/17/2014)

    I am not trying to be difficult but no one in this thread has answered my question. How does SQL know to look for anything trailing the AAA...

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

    February 17, 2014 at 9:41 pm

    #1689719

  • RE: To T-SQL or not to T-SQL?

    sqldriver (2/17/2014)

    I think doing that bit of pre-processing with PS should be fine; it's just one line, even if it is ~75 times.

    It would be interesting to see which approach...

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

    February 17, 2014 at 9:25 pm

    #1689717

  • RE: Best way to store images

    aframiller326 (2/13/2014)

    Jeff Moden (3/11/2013)

    I'd have to include FileStream in the same bucket as the "File Path Reference" approach with some reservations. To be sure, I've not used FileStream, yet...

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

    February 17, 2014 at 9:19 pm

    #1689716

  • RE: Audit table design

    eheraux (2/17/2014)

    Would a separate trigger need to be created for each field we wish to log?

    No. Inside one trigger you can test whether a column was changed by using 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)

    February 17, 2014 at 9:12 pm

    #1689715

  • RE: 15 minutes Interval from Hours - Please Help

    zulfansari (2/17/2014)

    Hi Jeff, Dwain.c and SQLRNNR,

    You guys are AWESOME..

    I really appreciate your help and learned new tips and tricks from all of you..

    God bless you all!

    Just an FYI, I ended...

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

    February 17, 2014 at 8:40 pm

    #1689713

  • RE: Backup and Housekeeping with Maintenance Plans

    I have to agree with the others. This would have been an absolute "must read" article, especially for newbies, if emails were sent out on the failure of any...

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

    February 17, 2014 at 6:16 pm

    #1689694

  • RE: T-sql help

    twin.devil (2/17/2014)

    you can check few things before joining these two tables

    let say u have check number in table 1 that i-e "12012410"

    and

    you have check number in table 2...

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

    February 17, 2014 at 5:03 am

    #1689454

  • RE: trying to add third grouping set to return average aggregate

    A classic CROSSTAB makes short work of this as a single "pivot" table. Please see the following article on what a CROSSTAB IS and how it works.

    http://www.sqlservercentral.com/articles/T-SQL/63681/

    SELECT ...

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

    February 17, 2014 at 1:44 am

    #1689417

  • RE: 15 minutes Interval from Hours - Please Help

    zulfansari (2/16/2014)

    Hi Jeff,

    Actually it's 0.25,0.50, etc. format, I made up the data for the post and used the wrong format.

    Thank you,

    Then a Tally Table will make the solution to this...

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

    February 17, 2014 at 12:42 am

    #1689413

  • RE: While Lop in Place of Cursor

    niladri.primalink (2/16/2014)

    Hi Jeff,

    I have forgot to mention it....Sorry for that.

    if the remainingCollectonCount =8 and the frequency =12 then in the futurecashflow table the next 12 months will be added by...

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

    February 17, 2014 at 12:27 am

    #1689411

  • RE: T-sql help

    As I said previously, there's going to have to be something other than just a check number. Even if check number is unique in both tables, there's no guarantee...

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

    February 17, 2014 at 12:09 am

    #1689410

  • RE: Management of DBA/DBD vs Programmers

    Cody K (2/16/2014)

    I think the managers understand the importance of it because they ask for it. But then once you start working on implementing that process, and you start getting...

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

    February 16, 2014 at 8:14 pm

    #1689396

  • RE: T-sql help

    movvap (2/16/2014)

    Note : There is no direct relation between these two tables but the b.ChequeNum and c.CheckNUmber have matching values. If there is defined relation then I can't join 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)

    February 16, 2014 at 7:26 pm

    #1689391

  • RE: 15 minutes Interval from Hours - Please Help

    zulfansari (2/14/2014)

    Hello SQL Gurus,

    I have a table with three columns, Person, Date, Hours. I need to turn hours into 15 minutes interval.

    Can someone please help?

    Thank you,

    Here is what I...

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

    February 16, 2014 at 7:19 pm

    #1689390

Viewing 15 posts - 24,361 through 24,375 (of 59,102 total)