I'm not a hard-core programmer, so forgive me if I say something more stupid than I usually do...

You'll get the number of units that should be displayed and you'll get...

You can go into the Advanced Properties of a step and set up a number of retry attempts and a retry interval. That ought to do what you need.

Check the code to see if it added the COLLATE key word after the parameter definition. That would cause the problem.

fshguo (5/23/2008)

---

I have upated the statistics, rebuild the indexes and apply Option Maxdop based on the recommendations, it looks like the situation has no change.

After I compared the execute...

Before I try to solve that, you might want to rethink the approach. If you fill out the rows for the user, even though there's no data, you either go...

dp (5/23/2008)

---

I have a table named Courses which contains course information as well as a column named No_Units, which gives the number of units this course should have. I...

Oooh. Excellent. I've got a lot of respect for Aikido. Very useful techniques. We've had people teach seminars on it so that we at least have a level of understanding...

I'd start with Itzik Ben-Gan's two books, Inside T-SQL Querying and Inside T-SQL Programming.

That's only one insert every 5.76 seconds. Even if you assume that all the records will come in over a 12 hour period that's only one every 2.5 seconds. Even...

It's just guesses without some code and structure.

If you step through the process, running the steps manually, can you see the data move appropriately? That's where I'd start.

You can certainly update from an inner join. That's easy. The trick is to get the join right to start with.

Instead of doing an update, write the whole thing as...

Since these are all pulling from the same table (except one of the queries) have you looked at either using an OUTER join or even an INNER join to pull...

I started in Seido in NYC where I got to green. Then I moved and restarted in Goju Ryu where I got to green. That dojo imploded. So I looked...

I'll go one further, use Matt's solution. That looks good from where I sit.

GilaMonster (5/22/2008)

---

Steve Jones - Editor (5/22/2008)

---

Tend to agree with Grant. Certification allows you to prove that you've learned things and been tested, but if you can't perform the things because...