blandry (7/8/2008)

---

...As for the explanation of Inner Joins themselves, the article is very basic and though for some that might be helpful, it was not very "real world" and did...

Between Turkey Week 1989 (Thanksgiving Week in the US) to August 1993, I drove 90 miles one way to work 5 days a week. Left the house at 6:00...

orrego.cesar (7/8/2008)

---

I have a big question (I guess that is big only for me), but... 'what is the real advantage of INNER JOIN??? why not to use WHERE condition to...

And this site is used internationally by many others than just us American's. We...

Jeff Moden (7/7/2008)

---

Marios Philippopoulos (7/7/2008)

---

2) Are you allowed to use sp_OA* procedures?

I don't know much about sp_OA* procedures, but I think they come with their own baggage of problems, and...

From BOL regarding the INSERT statement:

😎

Here's something, could the working trigger be interfering with the trigger that isn't working? Have you tried disabling (or deleting) the working one to see if the one you...

Though I didn't respond to your original post, I assure you, not a problem. Sometimes asking for help is all it takes. In asking for help, you had...

Yep! That's why I tried the logical exercise. Pretty much helps put it in perspective though.

😎

GSquared (7/3/2008)

---

Adding the Exists command seems to me to be unnecessary in any case. Will it actually resolve the lack of such rows more efficiently than the Delete command...

Way back in the days of Novell, didn't their Novell Certified Administrator require that you have at least one year experience before awarding the cert, and your company had to...

GSquared (7/3/2008)

---

Simon Facer (7/3/2008)

---

GSquared / Lynn, thanks for your insights.

So, it still comes down to the right technology in the right circumstance, you just need to know the different behaviours...

aayub (7/3/2008)

---

I have a table with the following format:

Sr1Col1 Col2Col3

1BU123456 80440

2BU123456 0KPMGF1

3BU123456 8044KPMGF1

4FC123456 80440

5FC123456 0KPMGF1

6FC123456 8044KPMGF1

7BU123456 00

8FC123456 00

Need help with an optimized query for.

The following conditions:

If we have an exact...

Truth be told, none of us do. The difference is between those who can admit it and those who can't.

Those who...

Okay, thanks. Unfortunately (?) we are looking at consolidating some of our servers, and will be using named instances where a separation is required.

😎