Avatar of MBoy
MBoy

asked on 

SQL - Conditional return of data

I'd like to remove any value from Data1 that is less than < 99

CREATE PROCEDURE [dbo].[KeyReportsAllEventsByOperator]
(
            @Operator As varchar(200)
)
AS
BEGIN
     SELECT
         [EventDateTime] As Date,
             [Vehicle],
             [Operator],
         [EventType] As Event,            
         [Data1],
         [Data2]
     FROM
         [RemoteData]
      WHERE @Operator = [Operator]
       ORDER BY [EventDateTime] DESC
END
GO
Microsoft SQL Server 2008

Avatar of undefined
Last Comment
Ephraim Wangoya

8/22/2022 - Mon