Am I late to the party? I was on a meeting.

Should I open the bottles of champagne? Who's in charge of the BBQ? :hehe:

Dark Side

More like inline views or single use views. You could also think of them as rearranged subqueries.

The engine will process all of this as a single statement, so you want...

The easiest way is to understand what each CTE is doing. Just go step by step.

The first one is your original query. The second one is a list of clients....

How do you define the max one?

I'm sorry, the ON clause shouldn't be there.

When you changed the code to include this:

FROM cteClients c

CROSS JOIN dbo.dimDate d where c.DATESERV = d.DateFull

You actually converted the CROSS JOIN...

sgmunson (8/10/2015)

---

Luis Cazares (8/10/2015)

---

sgmunson (8/10/2015)

---

Given the rather small size of the likely range of values here, any suffered performance is likely to be irrelevant, and the recursive CTE is a...

I'm not sure how much can it be improved, but to give more advice you need to share more information as described in here: http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

SQLRNNR (8/10/2015)

---

Brandie Tarvin (8/10/2015)

---

SQLRNNR (8/10/2015)

---

Alvin Ramard (8/10/2015)

---

Ed Wagner (8/10/2015)

---

Lynn Pettis (8/10/2015)

---

SQLRNNR (8/10/2015)

---

48 bottles of post on the thread, 48 bottles of post.

Take one down, pass it around, 48 bottles of...

As this should only be done for reporting, I'd suggest you to use only the rows needed instead of reading the 60 million rows. No one will ever need that...

Considering the following options. Which one is right?

CREATE TABLE #SampleData(

createdon datetime,

Kms_QuoteNumber varchar( 100))

INSERT INTO #SampleData

VALUES('2015-07-22 20:26:41.000', '15-35553/Rev9'),

...

sgmunson (8/10/2015)

---

Given the rather small size of the likely range of values here, any suffered performance is likely to be irrelevant, and the recursive CTE is a lot easier to...

What about using a different approach?

This might be what you're looking for.

SELECT TOP (1) kms_QuoteNumber

FROM quote

WHERE [kms_quotenumber] LIKE '15-35553%'

ORDER BY createdon DESC

Something like this as they're table valued functions:

SELECT UserName,

Password,

u.String AS CleanUserName,

p.String AS CleanPassword

FROM Customerstrings

CROSS APPLY dbo.StripNonAllowedChars( UserName) u

CROSS...

You need to create a cartesian product that includes all dates for all the clients. The following code might need to be divided as it might cause problems to the...