Forum Replies Created

Viewing 15 posts - 40,966 through 40,980 (of 59,069 total)

  • RE: Rant of the Day

    I agree with what Gail said and for the very same reasoning. However, I use TINYINT for things like this because it doesn't require any logic at all to...

    --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 25, 2009 at 2:17 pm

    #1084352

  • RE: Newbie Frustration - SQL Server 2000

    Bru Medishetty (11/25/2009)

    Use having clause at the end.

    having [Purchase_%] > 50

    I did not try on your query since I don't have the table / column details.

    Bru... if you copy 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 25, 2009 at 2:04 pm

    #1084348

  • RE: Newbie Frustration - SQL Server 2000

    CirquedeSQLeil (11/25/2009)

    Bru hinted at a very important thing here at SSC. We can offer suggestions for your query, but it is very difficult to provide accurate solutions without having...

    --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 25, 2009 at 2:02 pm

    #1084347

  • RE: Return most recent of a sub group of records

    Ron-279530 (11/25/2009)

    THanks for your feedback

    Heh... I'm going to assume that you still don't have an answer to your original question but, first...

    I notice from your post count that you're still...

    --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 25, 2009 at 2:00 pm

    #1084345

  • RE: updating data

    ... and it didn't take you long, either. đŸ™‚

    Just a couple of concerns for your code and data....

    1. Town names aren't unique and any given town name could appear...

    --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 25, 2009 at 1:28 pm

    #1084321

  • RE: Simple and fast front end for user to execute a stored procedure after keying a variable

    You could always do this in a spreadsheet with a pushbutton macro to read a cell (or an input message) and return the results to the spreadsheet.

    --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 25, 2009 at 12:58 pm

    #1084298

  • RE: Update HELP

    john scott miller (11/25/2009)

    Did you actually try that, John? It returns exactly the same phone number for all rows.

    --Jeff Moden

    -------------------------------------------------------------------------------------

    No i did not and that is why i am...

    --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 25, 2009 at 12:54 pm

    #1084295

  • RE: A welcome message to all Forum Newbies

    Heh... wow... people jumped on that post like white on rice... there' weren't any posts between the original and mine when I first looked at the post. Folks even...

    --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 25, 2009 at 12:40 pm

    #1084285

  • RE: A welcome message to all Forum Newbies

    It's a great idea and it's been suggested many times. But, just like a EULA, how do you guarantee that a newbie will actually read it never mind follow...

    --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 25, 2009 at 12:38 pm

    #1084284

  • RE: tempdb full

    Heh... wait a minute, now... how big are the MDF and LDF files for TempDB? How much freespace do the other DB's have? Have you verified that TempDB...

    --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 25, 2009 at 12:35 pm

    #1084280

  • RE: tempdb - understanding unallocated space

    repent_kog_is_near (11/24/2009)

    I am with you in principle. I am asking what is technically going on inside, that may block a shrink, even when there is enough unused space.

    Ah... got you....

    --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 25, 2009 at 12:31 pm

    #1084277

  • RE: Creating simple dynamic sql

    lonesome (11/23/2009)

    Thanks every body I solved my problem. Here is the solution.

    I am really grateful to every body for help and time

    ALTER PROCEDURE [dbo].[AdminSelectMovie]

    @Movies VARCHAR(20), --For where clause. 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 25, 2009 at 12:06 pm

    #1084260

  • RE: UPDATE question

    PiMané (11/25/2009)

    Thanks for the help but the problem with that is if I make

    UPDATE table SET col1 = col1, col2 = col2, col3 = 'xxxx' WHERE id = 1

    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)

    November 25, 2009 at 12:02 pm

    #1084259

  • RE: SELECT and REPLACE query

    john scott miller (11/24/2009)

    declare @oldip varchar(100)

    declare @newip varchar(100)

    select distinct oldip

    , newIp

    , 0 processed

    into #ips

    from tableName

    while exists ( select top 1 * from #ips where processed = 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)

    November 25, 2009 at 11:53 am

    #1084254

  • RE: SELECT and REPLACE query

    Magy (11/25/2009)

    Oh Im sorry, for oldIp I actually meant something like this:

    UPDATE myTable

    SET linkURL = REPLACE(linkURL, '192.49.42.39', '192.49.21.44')

    Actually, you should include the WHERE clause that Nabha used in his nearly...

    --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 25, 2009 at 11:50 am

    #1084251

Viewing 15 posts - 40,966 through 40,980 (of 59,069 total)