Less than 1 week –
Less than 10 hrs/week –
Need someone to optimise the attached sql statement so that you can replace the following statements as it puts all data from one table into a temp table only so it can use it to filter later on. this whole section can be replaced by rewriting so that the where clause does the same thing.
SELECT Equipment INTO #Priority FROM EMEM WITH (NOLOCK) WHERE Equipment is null --creates a empty equpiment table to help filter priorites on later
IF @JobPriority ...