Took another look at what you wrote, and realized maybe you meant tables with large numbers of rows, each of which needs to be parsed. So, I threw together...

Roy Ernest (3/6/2009)

---

I was not able to check this thread much yesterday since I had a late night shift the day before. I check today morning and this thread has...

Jeff Moden (3/5/2009)

---

Heh... Yeah... especially where I'm concerned... everyone knows I do nothing but write a...

GilaMonster (3/5/2009)

---

jcrawf02 (3/5/2009)

---

GSquared (3/5/2009)

---

all of them believe that not using global cursors on global temp tables is a violation of Object Oriented Programing principles and that "all you set-based idiots...

Jeff Moden (3/4/2009)

---

GSquared (3/4/2009)

---

The fastest way I know of to parse a simple string like that is to convert it to XML and then query that. That only works...

Have you tried the single-table test?

Something like that has some workability, Jack. But for a ratings system to work, I'd like to know who posted the rating.

For example, there have been plenty of people...

I have a question, also, on your proposed schema. Why would the required parent ID of Order be the ID of Class? I think you'd be better off...

Break it up into stages. Assuming your flat file has species and genus in it as columns, you import that into a table with the same columns as the...

You can have DTS in SQL 2005. Not in a wizard though. You can build a DTS package and deploy it on an SQL 2005 server. Will...

Jeff Moden (3/5/2009)

---

KevinC. (3/5/2009)

---

I really like having the OP state whether a particular answer helped them or not and why. I know it helps me when I'm trying to...

I would look at the hiring market around you, and judge by that. How many companies in your area have 2008 installations that need dev/admin work? How many...

You won't be able to apply a direct foreign key relationship to that column.

You could accomplish much the same by having two columns, one for hardware ID and one for...

Save it as a file...

Generically, make sure that the queries that populate the temp tables are properly set up (indexes, etc.), make sure that any of the temp tables that can benefit from indexes...