I have the following script: DECLARE @ConsultantID AS nVarChar ( 50 ) , @PeriodDate AS DateTime SET @ConsultantID = '0000344' SET @PeriodDate = '12-01-2007' -- Declare Local Variables Declare @MonthStartDt As DateTime DECLARE @MonthEndDt AS DateTime DECLARE @QuarterStartDt AS DateTime...

Hi, I have a stored procedure which is doing a select joining several tables based on certain conditions.There are two left outer joins and the rest are inner joins. We are using SQL Server 2000. The problem is that this particular procedure is taking unusally long time (10-12 mins) to execute in the...