riverswillbeer (11/20/2008)

---

Wow ... that would suck !! I thank you for the correction. I obviously try to solve the issue using web resources and trial...

Combination of that and "something else". Dunno if it'll be worth it, but wanted to give it...

You already have one. Any cursor code is going to be slow.

That's a pretty good and correct summary (heh... except for the format function). And, yes, you do understand.

You bet. Thank you for the feedback.

Now you know why I asked to see your query. For more information on how to get better answers quicker on future...

Works fine......

SELECT t.Title_ID, t.Type, t.Price, d.AvgPrice

FROM dbo.Titles t

INNER JOIN

(--==== Derived table "d" finds average Price for each...

Thanks for the feedback...

Just a bit of undocumented warning... we've had several problems in the past where using a correlated subquery in the WHERE clause of an update will occasionally...

Gaby A. (11/19/2008)

---

Thanks everybody, given me food for thought. Unfortunately this DB was set up before I joined my company but but at least in the future, if I...

Ted Zatopek (11/19/2008)

---

After lots of searching, I fanally ran across the term "fast parse" in an article and found the following MSDN article.

http://msdn.microsoft.com/en-us/library/ms139833(SQL.90).aspx

This seems to be just the trick I...

Show me your code so I can modify it for you.

Any feedback regarding my question, Karthick. Heh... "Inputs are welcome!" 😉

Sounds like a one time task... recommend you use SSIS to import the data into a "staging table" and then do an insert into the final table(s) from there.

Please see the following......

Jim Russell (11/19/2008)

---

Bringing in the entire...