Carrying Value Across Rows

  • Hey everyone, thanks for your posts. You all will probably be dissappointed but I've decided to instead use .Net (either via SSIS's Script Task or a Client App) in order to complete my solution. This piece I've given is a small piece of a larger puzzle, which involves lots of calculations of different period averages, weights, and I just found out - some Calculus :angry:.

    Thank you for your help though, this is still a valuable tool to keep in the toolbox for later use.

  • -deleted-

  • Gabriel P (8/10/2009)


    Hey everyone, thanks for your posts. You all will probably be dissappointed but I've decided to instead use .Net (either via SSIS's Script Task or a Client App) in order to complete my solution. This piece I've given is a small piece of a larger puzzle, which involves lots of calculations of different period averages, weights, and I just found out - some Calculus :angry:.

    Thank you for your help though, this is still a valuable tool to keep in the toolbox for later use.

    Who says you can't do that stuff in T-SQL? :hehe:

    If you run into performance problems because you have to go through the API to get to the data in the server, post back.

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

  • Hmmm... sounds pretty interesting! What kind of problem are you working on? Would it be possible for you to share some details with us - unless confidentiality requires otherwise...

    Saurabh Dwivedy
    ___________________________________________________________

    My Blog: http://tinyurl.com/dwivedys

    For better, quicker answers, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537

    Be Happy!

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply