Something like this?

;WITH cte AS

(

SELECT ROW_NUMBER() OVER(ORDER BY quote_date ) AS ROW, *

FROM #priceData

)

SELECT

cte1.*,

cte2.close_price AS Previous1,

cte3.close_price AS Previous2,

cte4.close_price AS Previous3,

cte5.close_price AS Previous4

FROM

cte cte1

LEFT...

Please post table def inclding foreign key refernces and some sample data as described in the first link in my signature. Also please post your expected output based on the...

Please don't cross post!

Replies at http://www.sqlservercentral.com/Forums/FindPost1030262.aspx

Please don't cross post!

Replies at http://www.sqlservercentral.com/Forums/FindPost1030262.aspx

Please don't cross post!

Replies at http://www.sqlservercentral.com/Forums/FindPost1030262.aspx

Edit: never mind. Misread the question

Another issue might be the table design by itself.

If you don't have a column that uniquely identifies a row, then your table structure isn't normalized.

The downside of it: you'll need...

amy26 (12/2/2010)

---

Cool thanks again, I actually edited my post after I just used google to look up the answer to my question! 🙂 I didn't realize we had actually...

Nope. The opposite.

Curently, you have it set to 1, meaning...

amy26 (12/2/2010)

---

About the parallelism: I was told that I should set this setting less than the available CPUs that are on the server. As we only have 2,...

Here are the ones I'm concerned about:

max degree of parallelism1

Are you sure to prevent parallel processing on the server level? Is the server mainly used for OLAP or OLTP processes?

Ole...

samartel (12/2/2010)

---

Wow....go grab a coffee and my post has a bunch of solutions....lol

I think what i'm going to do is actually redirect the file as an error. As GSquared...

Craig Farrell (12/2/2010)

---

LutzM (12/2/2010)

---

In that case, either an IIF statement or REGEX should help. (Google regex or IIF in ssis for details.)

You'd basically use a script component after your data...

In that case, either an IIF statement or REGEX should help. (Google regex or IIF in ssis for details.)

You'd basically use a script component after your data import to remove...

You might want to search this site for "string concatenate for xml path".

I'm sure FOR XML PATH will do the trick.