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

Lots of null columns. Lots. Without the query it's hard to comment, but I'll bet it's doing a table scan. Have you looked at the execution plan for the query?

You have an index, but is it being used properly? What do the execution plans look like? What's the selectivity of the data in that index, meanin, how unique is...

akeelm_uk (5/22/2008)

---

If you didn't know something didn't exist, how could you ever learn about it?

That is one area where I feel certification can be good, it encourages you to...

I'm not actively against certifications, but I sure don't care about them. I'm much more interested in what you know and how you show it than that you passed a...

Also, while lots of people may have one piece of knowledge or another, maybe a full set of the knowledge has never been put in one place before. I wrote...