Forum Replies Created

Viewing 15 posts - 44,401 through 44,415 (of 59,097 total)

  • RE: Concatenating Field Values

    Randy DeMasters (3/30/2009)

    I worked it out, if you choose add query on the binding source after setting up your dataset for your SP and then change the query to existing...

    --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 30, 2009 at 7:05 pm

    #968827

  • RE: Do DBAs Still Read Techincal Books?

    JacekO (3/30/2009)

    I hope when Jeff writes his book he will provide multiple methods for solving the problems with explanations why some solutions are better then other.

    You've just gotta know 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 30, 2009 at 4:34 pm

    #968776

  • RE: Do DBAs Still Read Techincal Books?

    Grant Fritchey (3/30/2009)

    Jeff Moden (3/29/2009)

    Heh... it's all your fault, ya know? Our conversations about 3 months ago are what started it all.

    Thanks for the feedback, Grant.

    Excellent. I'll take full...

    --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 30, 2009 at 4:28 pm

    #968770

  • RE: Do DBAs Still Read Techincal Books?

    Tony Davis (3/30/2009)

    ...the bleeding from one of Tony's editing sessions only lasts for three or four days, so don't worry.

    Don't worry, Jeff. I'll offer you as much help as...

    --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 30, 2009 at 4:26 pm

    #968769

  • RE: Are the posted questions getting worse?

    Lynn Pettis (3/30/2009)

    Jan Van der Eecken (3/30/2009)

    Geez, you are quick to pull out the rule book. Admitted, the pic is about the red card in the finals of a prof...

    --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 30, 2009 at 3:54 pm

    #968758

  • RE: Do DBAs Still Read Techincal Books?

    Steve Jones - Editor (3/29/2009)

    We're looking forward to seeing it on the front page here! I'm sure you'll have not shortage of good tech editors to spur you along.

    I understand...

    --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 29, 2009 at 8:42 pm

    #968131

  • RE: Do DBAs Still Read Techincal Books?

    Grant Fritchey (3/29/2009)

    Excellent. Congratulations and good luck.

    Heh... it's all your fault, ya know? Our conversations about 3 months ago are what started it all.

    Thanks for the feedback, Grant.

    --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 29, 2009 at 2:47 pm

    #968083

  • RE: Do DBAs Still Read Techincal Books?

    Absolutely unbelievable... I'm truly humbled by all your good urgings. Thank you all for your confidence.

    Apparently, you good folks aren't the only ones that think that I should write...

    --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 29, 2009 at 1:58 pm

    #968079

  • RE: Top 1000 of each group in a table

    Just add +1 to the following and you'll get your 60 months...

    where n.n <= DATEDIFF(m,@first_month,@last_month)[font="Arial Black"]+1[/font]

    --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 28, 2009 at 10:45 pm

    #967985

  • RE: Top 1000 of each group in a table

    Gabriel P (3/27/2009)

    I figured it out in case anyone is interested.

    declare @first_month datetime, @last_month datetime

    select @first_month = DATEADD(m,DateDiff(m,0,Min(sale_datetime)),0),

    @last_month = DATEADD(m,DateDiff(m,0,Max(sale_datetime)),0)

    from #temp

    select n.n, t1.*

    from #nums n

    cross apply (select top 10 *

    from...

    --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 28, 2009 at 9:44 pm

    #967983

  • RE: Basic SQL Exercises

    Jacob Pressures (3/27/2009)

    Thanks guys. So what, I'd have to subscribe to a forum to get all the different posts? Much of what i see often goes over my head....

    --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 28, 2009 at 6:21 pm

    #967972

  • RE: function to identify the special characters in a table

    SinghS (3/27/2009)

    I am struggling with same issue. I want to identify special characters at varchar column so that I can replace it with some other character.

    Example: “Hello World”

    Space between “Hello”...

    --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 28, 2009 at 6:17 pm

    #967971

  • RE: Need help with query

    David (3/28/2009)

    yes

    Heh... bad day, David?

    --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 28, 2009 at 6:12 pm

    #967970

  • RE: Comma Separated Values

    Koneru Murli Krishna (1/22/2007)

    I need deptno and against/beside it comma separated ename's for join dept.deptno=emp.deptno in a single query. Thanks in advance.

    Please see the link in my signature below... we...

    --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 28, 2009 at 6:10 pm

    #967969

  • RE: Trigger question

    Ummmm.... the only way a DELETE trigger that updates the table will cause other triggers to fire is if Cascade Triggers is turned on. It's not normally a 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)

    March 28, 2009 at 6:06 pm

    #967968

Viewing 15 posts - 44,401 through 44,415 (of 59,097 total)