Viewing 2 posts - 1 through 3 (of 3 total)
I solved this by using a case to compare the column against a lagged version.For example: case when B.CPNITMREF_0=LAG(B.CPNITMREF_0,1,NULL) over (order by B.BOMSEQ_0, YSTOFCY_0, PIO_0, I.BPSNUM_0) then NULL else B.CPNITMREF_0...
November 6, 2017 at 7:26 am
#1966777
April 12, 2017 at 7:57 am
#1937844