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 6:19 am

    #1891798

    Anandkumar-SQL_Developer (7/25/2016)

    Hi this code also work :

    SELECT Value

    FROM

    #first_nonzero

    WHERE %%PhysLoc%% >=

    (

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

    )

    Not necessarily, the physical location of a row might not have the desired order.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2