Someone

public text v1 · immutable

#412463

·published 2007-03-27 18:25 UTC

CREATE PROCEDURE dbo.viewLogs 
@searchQuery varchar(500), @orderBy varchar(50), @orderList varchar(50)
AS
BEGIN
SELECT Plog,Status,Priority,DateReported,LastModified,Environment,Applications,ReporterName,DepartmentName,ProblemDetails,ResolvedBy
FROm OccurrenceLogs 
WHERE Plog like @searchQuery OR Status like @searchQuery OR Priority like @searchQuery OR DateReported like @searchQuery OR LastModified like @searchQuery OR Environment like @searchQuery OR Applications like @searchQuery OR ReporterName like @searchQuery OR DepartmentName like @searchQuery OR ProblemDetails like @searchQuery OR ResolvedBy like @searchQuery
ORDER BY @orderBy @orderList
END
GO