arthur.bekker (3/18/2015)

---

I think anyone who wants to use CTEs should read this article http://sqlblogcasts.com/blogs/tonyrogerson/archive/2008/05/17/non-recursive-common-table-expressions-performance-sucks-1-cte-self-join-cte-sub-query-inline-expansion.aspx....

I showed the Execution Plan to this guy and he said that he wanted to "concrete" his...

Katerine459 (3/18/2015)

---

So, I've been reading the discussion on the latest Stairway article about CTEs (http://www.sqlservercentral.com/Forums/Topic1660966-34-1.aspx), and a bunch of people are talking about how CTEs are performance hogs. And now...

jhood (3/18/2015)

---

The recursive cte should never be used if you are concerned with performance.

The recursion resolves row by row instead of sets. A while loop with temp tables...

g.britton (3/18/2015)

---

One other nice use: CTE as target table

You can write this:

WITH CTE AS

(

SELECT somecolums,....

FROM sometable

WHERE...

chris.puncher (3/18/2015)

---

Just worth pointing out that CTEs against large tables can be very slow; something I have had first hand experience of.

Here is an alternative method that proved much more...

Great article. One correction however:

Emphasis mine...

Not true... You...

Had a few moments to kill... Here's an example of how to solve this using the link that I provided.

Note that I don't understand where, in row 1 of...

This article should help:

Solving the Running Total and Ordinal Rank Problems[/url]

This is a very good article on this subject:

http://sqlinthewild.co.za/index.php/2009/08/17/exists-vs-in/[/url]

Here's a solution.

I'm sure there is an easier way but this is a cursor/loop-free way that will work.

/*Assumptions

(1) There are alway 2 product names that are equal...

I have a solution but need a little clarification...

What exactly do you mean by

For example, Let's say Amount1 is 1051 and...

For DR and Reporting purposes you old use replication but I don't think it's the best solution. You would have a lot of publishers to deal and a lot...

First, Louis' solution is brilliant; I tried for a couple hours to come up with something faster (that does not utilize a calendar table) and failed.

So here's my calendar...

dwain.c (3/11/2015)

---

This is quite easy to do if you already have a calendar table that stores that information:

Calendar Tables in T-SQL[/url]

The GenerateCalendar FUNCTION included in that article shows how it...

andyscott (3/11/2015)

---

How about this group of ctes? The first cte creates a table of Dates for the current year, the second cte expands these to add the Year, Month and...