Sorry, I accept that I may be being dense here but as far as I can see you still haven't said what you actually want in your result-set.

Hmmm. . . it is after all still a loop.

However, I'm not sure why you'd want to convert a recursive CTE into a while loop -...

cdh-727733 (2/7/2012)

---

I have a hierarchy setup to store product categories as below :

ID int

ParentID int

CategoryName varchar(50)

My products are categorised only at the leaf level.

My general category navigation I have got...

niktaxi (2/7/2012)

---

All right. For instance, I am supposed to take these results for diabetes:

pname from pname to infection hname infection date diagnosis hname diagnosis date

Christina Winslet Sotiris Chen Maimonides 1916/02/01...

alex.newsum (2/7/2012)

---

Thanks for your post, unfortunately not as non of the date formats set by SQL code are the long "01 January 2012". But I do not understand why a...

Jason-299789 (2/7/2012)

---

A quick Question in SQL 2008 doesnt the OPTION(RECOMPILE) on a query force that query to recompile its plan based on the values thus eliminating the need for Parameter...

Do you know all of the codes? Can you create a look-up table with all of the codes in?

Late

erikpoker (2/7/2012)

---

English is not my first language, so i might not get my point across well.

For simplicity, lets say i only grouped by two columns in the query. Account_FK and...

erikpoker (2/7/2012)

---

Cadavre (2/7/2012)

In the slow running query, your statistics look out of date (e.g. you have a hash match operator that is estimating 7 rows but the actual number of...

Hey guys, I'm out of my depth here, query tuning without knowing a massive amount of detail is impossible for me. I've managed to get execution plans posted, but...

No problem.

In the slow running query, your statistics look out of date (e.g. you...

Totally agreed,...

Can you attach the .sqlplan ? An image is no good.

erikpoker (2/7/2012)

---

Thanks for your input.

However i cant see how the blogpost relates to my queries.

The inputed parameters is always provided (never nulls) so there is not much use to use...