Forum Replies Created

Viewing 15 posts - 19,141 through 19,155 (of 59,098 total)

  • RE: Please help to resolve issue in SQL Query

    ChrisM@Work (11/19/2015)

    Always test:

    +1000

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

    November 19, 2015 at 11:09 am

    #1841107

  • RE: How to get 'Year' in a case statement

    cory.bullard76 (11/19/2015)

    Thanks! For the help. I was thinking that I had to put the convert code at the end (ex. Convert(Varchar....101)...so that kept me from doing 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)

    November 19, 2015 at 11:05 am

    #1841104

  • RE: UPDATE statement help

    Ya just gotta love the way people come together to simplify things on some of these posts. Thanks folks.

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

    November 19, 2015 at 10:53 am

    #1841098

  • RE: concatenation of two columns as single

    Robert vd Berg (11/19/2015)

    Is this what your looking for?

    SELECTdbo.agent_datetime(run_date, run_time)

    FROMsysjobhistory;

    You beat me to it. It's not the epitome of efficiency but it's usually good enough. Luis' "iSF" would...

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

    November 19, 2015 at 9:13 am

    #1841047

  • RE: Good Basic T-SQL Exercises

    Steve Jones - SSC Editor (11/19/2015)

    Here, though not sure how/why/when. I am trying to get some POC together that could be used to help people walk a path, but be...

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

    November 19, 2015 at 9:11 am

    #1841044

  • RE: dynamic cursor

    Easy guys. 'Tis the season to be jolly. 🙂

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

    November 19, 2015 at 9:09 am

    #1841043

  • RE: Insert into select from - View

    @Minnu,

    I don't mean this as a slam. It's a recommendation. This is some pretty basic stuff that you're talking about and, if your job requires you to work...

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

    November 19, 2015 at 8:45 am

    #1841034

  • RE: UPDATE statement help

    ChrisM@Work (11/19/2015)

    Shamelessly nicking Jeff's sample data:

    --===== If it exists, drop the test table to make reruns easier in SSMS.

    -- This is NOT a part of the solution.

    IF OBJECT_ID('tempdb..#TestTable','U') IS NOT...

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

    November 19, 2015 at 7:00 am

    #1840969

  • RE: UPDATE statement help

    serg-52 (11/19/2015)

    Jeff Moden (11/18/2015)

    I believe that using something like "Lead/Lag" would do the same thing faster but I don't have 2012 on the machine that I'm currently working on and...

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

    November 19, 2015 at 6:54 am

    #1840967

  • RE: UPDATE statement help

    Jason-299789 (11/19/2015)

    Jeff,

    I dont think Lead/Lag will help in this case as it will only update by a given offset, so using the example

    SELECT

    #TestTable.*

    ,LEAD(class4,1,class4) OVER (PARTITION BY identifier ORDER...

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

    November 19, 2015 at 6:51 am

    #1840965

  • RE: SQL Query question

    For future posts, please help us help you. Please read the article at the first link under "Helpful Links" in my signature line at the end of this post....

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

    November 18, 2015 at 10:25 pm

    #1840878

  • RE: UPDATE statement help

    For future posts, help make it easy for people to help you. Please see the first link under "Helpful Links" in my signature line at the end of 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)

    November 18, 2015 at 9:15 pm

    #1840876

  • RE: Nested Schemas

    Luis Cazares (11/18/2015)

    Carlo Romagnano (11/18/2015)

    patricklambin (11/18/2015)

    I would advice to prohibit this way of coding/naming.

    I disagree, naming conventions should reflect the factory needs. So, it may be that [Sales.XXX] is good...

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

    November 18, 2015 at 8:47 pm

    #1840875

  • RE: Referencing function from another database in CREATE TABLE stmt

    SoHelpMeCodd (11/18/2015)

    The model database can be restored to other instances, but each instance must be running the same SQL Server build. And if the master database is rebuilt, the model...

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

    November 18, 2015 at 8:34 pm

    #1840874

  • RE: Positive or Negative

    SQLBill (10/28/2015)

    Jeff Moden (10/26/2015)

    SQLBill (10/26/2015)

    The way I would determine which to use (Active or Inactive) would depend on how I am going to query the data. I use "pseudo...

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

    November 18, 2015 at 6:23 pm

    #1840870

Viewing 15 posts - 19,141 through 19,155 (of 59,098 total)