Most definitely not! Copy and paste may save a few seconds during initial development, but can cause hours or days of agony...

Generally with this sort of refactoring there is no change in performance, good or bad. You should see identical execution plans.

I didn't need the database schema I need the table schema that is the CREATE TABLE statement. also please post some sample data and the desired up with using that...

You need to post the table schemas involved, some sample input data and desired output using the sample data

Alan.B (3/18/2015)

---

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"...

One other nice use: CTE as target table

You can write this:

WITH CTE AS

(

SELECT somecolums,....

FROM sometable

WHERE somefilters

)

UPDATE...

Yes. that is true. Note that one...

CTEs as basically just another (more linear) way to write sub queries. If you don't use recursion, performance will be the same as if you had used subqueries...

Use a script component for the source and pass in the variable containing the delimiter

Hi! Love this stairway!

Quick question: Why do you you use Notepad to read the log output? I usually just open it in Visual Studio

What I especially <sarcasm>love</sarcasm> is students that post homework questions without making any attempt to solve the problem or even, apparently, work on it at all.

In SSIS, the column delimiter is actually per column, which is why you don't see a property for it.

GilaMonster (3/13/2015)

---

Be careful of using a function in a constraint. The constraint only gets checked when the table that it is on changes. If the table that the function reads...

Try all caps: /IACCEPTSQLSERVERLICENSETERMS

So, what IS the PK used for?