Home Forums SQL Server 2016 SQL Server 2016 - Development and T-SQL Exclude zero till get first nonzero value.(use cte or select) RE: Exclude zero till get first nonzero value.(use cte or select)

  • July 25, 2016 at 4:24 am

    #1891789

    Hi this code also work :

    SELECT Value

    FROM

    #first_nonzero

    WHERE %%PhysLoc%% >=

    (

    SELECT MIN(%%PhysLoc%%) FROM #first_nonzero WHERE VALUE > 0

    )