I have to agree with Phil. When I first started visiting this site, I mostly read, but did post a few questions here and there. But what I...

dan (11/26/2008)

---

Hi All

In our design, we have a Notes table, which can be linked to many other tables (Supplier, WorkItem, Quote and so on), which allows us to store notes...

Julio Conejo (11/26/2008)

---

With this example in mind, the full started at 12am, and finished at 5 am, but the chief tells us that at 3:01 am one stupid employee did...

I served 4 years in the Country Club (aka USAF) as a computer operator, even graduated as an Honor Grad from tech school. It didn't truely prepare me for...

Can you say gulliable, or maybe good-hearted?

For all the faults of the "bad posts" we are a community that cares. And, who knows, maybe some of these individuals can...

Me thinks you will need to repost your question here on this thread, complete with tables, sample data, and expected results.

Nice.

I also liked his responses to your posts. He answered your questions, provided sample data; all in...

Ya think? :w00t:

The autoincrement column would be a primary key. This key would not be visible to the users, just to the database. It would be used to link related...

Here is the last thing I would with the code. In your select list in the UPDATE statement, I would alias the column names with the table aliases from...

Lucas Davenport (11/25/2008)

---

There is another option . . . .

Set the SQL Server so that changes may be made to system catalogs (RC Server in EM, Properties, Server Settings)....

AND, show us what your expected results should like like from the query. Nothing you have posted so far helps us understand what you are actually looking for in...

Also, don't just edit your post, add a reply to it. If you just edit your original post, no one but you will know that you did, and your...

First, yes, you should read the article that both Seth and I have in our signature blocks. It would make working on your "opportunities" easier. Luckily, things are...

Michael Valentine Jones (11/25/2008)

---

In that case, let me jump in. 😀

There are many opinions of this subject, but I am...