Ninja's_RGR'us (7/7/2011)

---

That's the only chance you have to tune this.

http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

Once that's done, post the new execution plans and I'll see if I can help further.

P.S. Of the 17 parameters, are...

Oh sorry about that...there are a total...

Just forgot to tell you this is a cascading report but still the...

Thanks for your reply. Below is the main SP:

-----------------------------------------------------

USE [TMIS]

GO

/****** Object: ...

Ninja's_RGR'us (7/5/2011)

---

What errors are you getting?

The whole point of that table is to give you the ability to join to it on a date value and fetch all other date...

Thanks...but I am not sure what to do with it...and besides its not creating a table and giving errors. This is quite new to me and...

Sorry to bother you but could you help me on this one:

http://www.sqlservercentral.com/Forums/Topic1135057-149-1.aspx#bm1135850

I have tried different scenarios but some I unable to comprehed while others just...

Ninja's_RGR'us (7/4/2011)

---

quan23 (7/4/2011)

---

Aha, I was thinking that local #tmp tables don't have statistics generated for them, but I was getting confused with table variables

That solves the potential issue with concurrent...

Ninja's_RGR'us (7/4/2011)

---

quan23 (7/4/2011)

---

Would you make the creation of the temp table conditional so you only create it if the passed in parameter contains a ',' character?

(I am assuming here...

Hi, Thanks, pls find the SP code below(its actually a sub-procedure):

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[usp_QM_Details_Sailing]

...

quan23 (7/4/2011)

---

I don't think it sounds like the cascade that is the problem, otherwise you wouldn't be able to select values for all the parameters

Have you set up the parameters...

LutzM (7/1/2011)

---

Assuming you're looking for the ISO week number the DATEFIRST approach won't help you at all. The ISO week number depends on the weekday of January 1st.

Since you're using...

quan23 (7/1/2011)

---

You can avoid creating a dataset if you specify the available list of values, so if you have a...

Ninja's_RGR'us (6/29/2011)

---

I'm really not sure what you mean about questions 1 & 2. What context are you reffering to?

Also on #1 I never had that error so I can't...

Ninja's_RGR'us (6/28/2011)

---

Those articles are a great read and I would strongly recommend you read them.

HOWever,

I've been having a very similar issue in bids where the local machine just ain't...