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