Forum Replies Created

Viewing 15 posts - 39,391 through 39,405 (of 59,072 total)

  • RE: Having total amount at every row level

    akmerve (3/9/2010)

    Hello,

    I'd like to have total value of amount paid (PAID) iterated at every row level. For instance, by using the query shown below, I would be able 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)

    March 10, 2010 at 6:11 pm

    #1131737

  • RE: Having total amount at every row level

    Thanks for the article referral, Chris. 🙂

    --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 10, 2010 at 6:09 pm

    #1131736

  • RE: Complicated Quey help

    Saravanan_tvr (3/10/2010)

    Hi,.

    I have a table for example

    table 1

    columns are : Item_no , stock1,stock2 ,date

    rows ...

    --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 10, 2010 at 6:00 pm

    #1131734

  • RE: select all field except field wich have NULL value

    vaibhav.tiwari (3/10/2010)

    Bhuvnesh (3/10/2010)

    sinamora (3/9/2010)

    Day1 Day2 Day3 Day4 Day5

    12 3 ...

    --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 10, 2010 at 5:55 pm

    #1131733

  • RE: Why use N before any string

    Make sure that you understand the last part of that Books Online entry... it uses 2 BYTES for every character. That's twice the network traffic, twice the memory used,...

    --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 10, 2010 at 5:53 pm

    #1131732

  • RE: Check Duplicate

    mail2payan (3/10/2010)

    I want to know, what can be the combined insert/update trigger for this!!

    Ummmm... no... a trigger isn't the place for such code. You should already know if 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 10, 2010 at 5:49 pm

    #1131730

  • RE: DateFunction

    kaladharreddy15 (3/9/2010)

    Write a query based on Customer table that returns list of customers having same birthday. List all

    groups.

    Heh... this is a simple query and it sounds a whole lot 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 10, 2010 at 5:45 pm

    #1131728

  • RE: Improve Searches

    I agree... depending on what the search criteria is, an index can help a lot.

    A word of caution on DTA... it can and will frequently lead you down the primrose...

    --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 10, 2010 at 5:44 pm

    #1131726

  • RE: Data Type size

    GTR (3/9/2010)

    Because even if you don't use complete space for particular data types it will allocate and reserve the maximum size, you will be wasting resources.

    I don't believe that's true...

    --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 10, 2010 at 5:40 pm

    #1131725

  • RE: t-sql help

    Mh-397891 (3/10/2010)

    This script works fine if the table has primary key defined on single column, but it gets complicated if the table has primary key defined on more than one...

    --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 10, 2010 at 5:30 pm

    #1131724

  • RE: SQL Backup Location and Timing details

    ramyours2003 (3/9/2010)

    thanks for ur responses the link which u mentioned is not opening .

    The link that Lynn posted will work if you paste it into the URL box in SQL...

    --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 10, 2010 at 5:00 pm

    #1131720

  • RE: Removing Blank Fields

    Paul_Harvey (3/10/2010)

    Hi All,

    Hopefully an easy one for somebody in "the know".

    I have a table with some 75 fields, that acts as a staging table for incoming data feeds.

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

    March 10, 2010 at 4:51 pm

    #1131718

  • RE: Using Row_Number() Over Partition By

    Jacob Pressures (3/10/2010)

    I'm looking at the data in the table and i see the problem (I THINK), RTRIM and LTRIM did not remove the square characters at the end. Evidently...

    --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 10, 2010 at 4:45 pm

    #1131716

  • RE: T-SQL help

    preetshari (3/10/2010)

    I have a list of ids in a particular order. I am passing this as a comma-delimited string to a stored procedure. I need to update a table 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 10, 2010 at 4:41 pm

    #1131715

  • RE: Cannot Shrink Database

    It also works from SSMS when you shrink at the file level and tell it to reorganize before shrinking.

    --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 10, 2010 at 4:39 pm

    #1131713

Viewing 15 posts - 39,391 through 39,405 (of 59,072 total)