Forum Replies Created

Viewing 15 posts - 50,806 through 50,820 (of 59,102 total)

  • RE: Export SQL unique format

    Sorry, my mistake... you don't need a CASE at all...

    DECLARE @DemoTable TABLE (Amount VARCHAR(15))

    INSERT INTO @DemoTable (Amount)

    SELECT '$102.50' UNION ALL

    SELECT '-$57.75'

    SELECT REPLACE(STR(ABS(CAST(Amount AS MONEY)*100.0),8),' ','0')

    ...

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

    May 2, 2008 at 8:20 pm

    #810393

  • RE: Export SQL unique format

    Don't need a case statement to figure the zero's...

    DECLARE @DemoTable TABLE (Amount VARCHAR(15))

    INSERT INTO @DemoTable (Amount)

    SELECT '$102.50' UNION ALL

    SELECT '-$57.75'

    SELECT REPLACE(STR(ABS(CAST(Amount AS MONEY)*100.0),8),' ','0')

    ...

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

    May 2, 2008 at 8:16 pm

    #810392

  • RE: SQL Server Project

    You want projects to practice on? Why go anywhere else... stay on this forum and start answering questions. You won't find a better or more diverse set of...

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

    May 2, 2008 at 7:55 pm

    #810389

  • RE: Last time when did the SP run

    So, turn it on... end of proc trace takes no overhead and beats the heck out of modifying 300+ procs 🙂

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

    May 2, 2008 at 7:16 pm

    #810387

  • RE: The T-SQL Quiz

    Matt Miller (5/2/2008)

    Grant Fritchey (5/2/2008)

    How did you know what I had planned for the week-end... 😀

    I have to ask though, what's drowning breath exercise? While we do incorporate a lot...

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

    May 2, 2008 at 7:14 pm

    #810385

  • RE: The T-SQL Quiz

    DFalso, if you get hit by a bus tomorrow and your boss can't figure out your code, then you're proving exactly what I said... your code is not production quality...

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

    May 2, 2008 at 7:07 pm

    #810384

  • RE: Row-By-Row Processing Without Cursor

    poornima.s_pdi (5/1/2008)

    Hi Jeff,

    Thanks a lot for ur reply.I learnt more from ur sites.very good snd useful forum...

    Thank you for the feed back, Poornima... are you all set now?

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

    May 2, 2008 at 6:54 pm

    #810383

  • RE: Row-By-Row Processing Without Cursor

    Funny, they work fine for me... they take me right to the post I wanted.

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

    May 2, 2008 at 6:52 pm

    #810382

  • RE: Add a temp unique ID column to a view?

    ebarsamian (5/2/2008)

    Thanks for the help. This is the sql that puts the stored procedure into a temp table with a unique ID:

    CREATE TABLE #trustgoals

    (ID int IDENTITY,

    Trust varchar(100),

    InitialReview varchar(100),

    ReReview varchar(100),

    TotalReview...

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

    May 2, 2008 at 6:49 pm

    #810381

  • RE: Another Crappy Cursor

    By the way, MDevore, very nice formatting you did on your code. Makes for a really easy read. Nicely done!

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

    May 2, 2008 at 6:43 pm

    #810380

  • RE: Another Crappy Cursor

    mdevore (5/2/2008)

    HOLY CRAP! :w00t::w00t::w00t::w00t: I rewrote the query based on Jeff's Running Total post, and it went from 8 hours to 6 seconds! Jeff, I bow down before you! THANKS!!!!!!!

    Heh......

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

    May 2, 2008 at 2:52 pm

    #810354

  • RE: Add a temp unique ID column to a view?

    Post what you have for the view already, please.

    Strange that something should require a view 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)

    May 2, 2008 at 2:44 pm

    #810350

  • RE: Dynamic View creation is taking long time

    Part of the problem is that you go back to delete the trailing comma... you basically do something like this...

    DECLARE @somestring VARCHAR(8000)

    SET @somestring = ''

    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)

    May 2, 2008 at 8:09 am

    #810097

  • RE: Working with strings

    And, you need that in a file 100,000 columns wide, right? You trolling here or ??? I ask because you asked for comma delimited in the first 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)

    May 2, 2008 at 7:39 am

    #810071

  • RE: Fetch Row by Row with out using cursor

    shalini_pdi (5/2/2008)

    Hi Jeff

    I m getting error when i get the query based on some condition as i have mentioned in previous post

    "I am getting the error as Violation of PRIMARY...

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

    May 2, 2008 at 7:10 am

    #810054

Viewing 15 posts - 50,806 through 50,820 (of 59,102 total)