CREATE PROCEDURE dbo.viewLogs @searchQuery varchar(500), @orderBy varchar(50), @orderList varchar(50)ASBEGINSELECT Plog,Status,Priority,DateReported,LastModified,Environment,Applications,ReporterName,DepartmentName,ProblemDetails,ResolvedByFROm 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 @searchQueryORDER BY @orderBy @orderListENDGO