You must Sign In to post a response.
  • Category: SQL Server

    Difference of value on new row

    Hi Team,
    I have table as follows
    ROWID Labeldate Onhand ate onhandvalue
    1 4/1/2015 NULL 21
    2 5/1/2015 NULL 22
    3 6/1/2015 NULL 0
    4 7/1/2015 NULL 0
    5 8/1/2015 NULL 0
    6 9/1/2015 NULL 0
    7 10/1/2015 NULL 0
    8 11/1/2015 NULL 0
    9 12/1/2015 NULL 0
    10 1/1/2016 NULL 0
    11 2/1/2016 2/1/2016 360
    12 3/1/2016 NULL 0

    I need to assign one onhanddate val to other date on hand val
    Example :
    1 4/1/2015 NULL 21
    2 5/1/2015 NULL 21
    3 6/1/2015 NULL 22
    Can any anbody post query to get result set like this
    Thanks in Advance
  • #764989
    we are not able to understand the logic which you are telling. Can you give little bit more details about the logic which you are trying to tel.
    By Nathan
    Direction is important than speed

  • #765008
    Hi,

    Not understand you requirement, could you please elaborate little bit in depth so that we can help you better.

    --------------------------------------------------------------------------------
    Give respect to your work, Instead of trying to impress your boss.

    N@veen
    Blog : http://naveens-dotnet.blogspot.in/


Sign In to post your comments