USP_DATALIST_ANALYTICSPROJECTDELIVERYRESULTS

CREATE procedure dbo.USP_DATALIST_ANALYTICSPROJECTDELIVERYRESULTS
as
    set nocount on;

    select
        ID,
        DATE
    from
        dbo.ANALYTICSPROJECT
    where
        RECALIBRATION = 1
        or RECORDSSCORED > 0
        or RECORDSBOUGHT > 0
        or len(DESCRIPTION) > 0
        or DISTRIBUTION is not null
        or PRESENTATION1 is not null
        or PRESENTATION2 is not null
        or PRESENTATION3 is not null
        or PRESENTATION4 is not null
        or PRESENTATION5 is not null
    order by
        ANALYTICSPROJECT.DATE desc;