Get the prvious value

• ekknaveen

  SSCrazy

  Points: 2317

  More actions

  September 13, 2013 at 1:04 am

  #282355

  Hi,

  I am having the below records

  Date value

  01-01-2013 10

  02-01-2013 20

  03-01-2013 0

  04-01-2013 0

  05-01-2013 30

  06-01-2013 40

  07-01-2013 0

  08-01-2013 50

  I want to display the value 20 for the dates 3rd and 4th and value 40 for the date 07th.

  In general, for any date if the value is 0 then get the privoud non zero value.

  Can anyone pls help me to get this one

  Thanks

  Naveen

• Koen Verbeeck

  SSC Guru

  Points: 259155

  More actions

  September 13, 2013 at 3:24 am

  #1649997

  Duplicate post. Original post with replies can be found here:

  http://www.sqlservercentral.com/Forums/Topic1494482-145-1.aspx

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP