Viewing 5 posts - 1 through 5 (of 5 total)
Hello SQL Experts .. Any help on this is highly appreciated.
July 10, 2015 at 3:33 pm
insert into #try values(2, 200,null,10)
insert into #try values(3, 300,200,20)
insert into #try values(4, 400,300,15)
insert into #try values(5, 500,400,40)
we need to get prior max based on source and destno. for each sourceno...
July 2, 2015 at 12:15 pm
The Result should be
1,100,null,10
5,500,400,20
7,700,null,4
8,800,600,2
June 30, 2015 at 4:27 pm
Yes if there is sourceno then you need to get its quantity till it reaches null. and then calculate the prior max for the lastest ID.
June 25, 2015 at 4:15 pm
correction result should be
1,100,null,10
5,500,400,20
7,700,null,4
8,800,600,2
June 25, 2015 at 1:06 am
Viewing 5 posts - 1 through 5 (of 5 total)