Forum Replies Created

Viewing 15 posts - 44,596 through 44,610 (of 59,095 total)

  • RE: Issue with CTE

    Heh... stupid me... of course it's set to 9 or you'd have gotten a message about the CTE. Sorry.

    Can you post your final code? I just wanna make...

    --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 8:59 pm

    #959844

  • RE: Issue with CTE

    siddartha pal (3/12/2009)

    I am not able to complie the function because of Varchar(max) for @string parameter.

    Siddartha,

    Check the compatibility level of the database... if it's set to "8", then the database...

    --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 8:28 pm

    #959842

  • RE: Where do I start?!

    WebTechie38 (3/14/2009)

    How do you slow the boss down to document the environment, plan backups and develop a test environment when he hired you for all the "NEW" stuff for 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)

    March 14, 2009 at 8:13 pm

    #959837

  • RE: T-Sql rant

    foxjazz (3/14/2009)

    Why not have t-sql be capable of merging with other languages by preference?

    Heh... I told you that it actually is, before... you can write all your stored procedures 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)

    March 14, 2009 at 8:05 pm

    #959833

  • RE: T-Sql rant

    Heh... definitely not. English only here. Of course, if I need something done in Germany, I get a translator.

    Same goes with code... GUI programmers shouldn't 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)

    March 14, 2009 at 8:01 pm

    #959832

  • RE: String Manipulation

    Goldie Graber (3/14/2009)

    Jeff Moden (3/14/2009)

    Hi Goldie...

    Not sure I can help but it would make it easier to try if you attached a file that has an example HTML 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 7:43 pm

    #959830

  • RE: T-Sql rant

    RBarryYoung (3/14/2009)

    OK, foxjazz, now I have a question for you:

    foxjazz (3/14/2009)

    Ok, yes I did it that way before. Except you have to do it in 4 distinct query sets, 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)

    March 14, 2009 at 7:39 pm

    #959826

  • RE: T-Sql rant

    foxjazz (3/14/2009)

    Instead of having you guys try and figure out some problem without the use of cursors, I have already made my point without realizing that I had.

    Simply because 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 7:23 pm

    #959822

  • RE: T-Sql rant

    foxjazz (3/14/2009)

    Ok, yes I did it that way before. Except you have to do it in 4 distinct query sets, and link the first results to the other set, 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)

    March 14, 2009 at 7:06 pm

    #959818

  • 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

Viewing 15 posts - 44,596 through 44,610 (of 59,095 total)