Viewing 2 posts - 1 through 2 (of 2 total)
Running sum would do it for you.......
SELECT *,
CASE WHEN colC IS NULL
THEN NULL
ELSE SUM( IIF(colC IS NULL, 0, 1) ) OVER (ORDER BY ID ROWS BETWEEN UNBOUNDED...
February 2, 2015 at 1:40 am
#1774706
Meant to rate it 5 Stars. Pushed one by accident - sorry
Great article Jeff
/Steen
October 12, 2013 at 7:15 am
#1658061