So, what was...

Agreed. Sloppy programmers don't have much success with...

Ever hear of the Yugo? :hehe:

Lynn Pettis (8/16/2012)

---

I have to disagree with you. First, C & C++ programmers don't know things from the get go, they had to learn about the penalties for using...

roger.plowman (8/16/2012)

---

Much of my objection to C comes from the sheer grunt work of memory management. C is notorious for memory leaks and buffer overflows. While VB dialects before VB.Net...

Ah,...

Alex Gay (8/16/2012)

---

I wouldn't recommend C as a starting language, but once you can program it is always good to learn what your compiler is doing behind the scenes, or...

rrn 62873 (8/15/2012)

---

Thank you for the tips.

Specifying the index as unique did shave off time in the overall processing from what I had tested previously.

But creating the index after the...

Man this is one ugly POS, probably written by a VB programmer.

Yes, it can be re-written to be set based and it would run light years faster. To be honest...

try inserting into the temp table without an index (or just use select into ) and without the order by, then create the clustered index after the insert.

Also, create...

I hate it when UPDATE doesn't update correctly.

CELKO (8/11/2012)

---

But I do not want you to quit sniping at me. I like adversarial...

Eugene Elutin (8/10/2012)

---

But the reality is that natural and surrogate keys each have their advantages and disadvantages, and there is no solution which is perfect for all situations. In...

The underlying functionality is the same, but the DDL is different....

looks like a homework assignment. You should read the textbook and do the labs. :-P:-P