R.P., did you set up a 10k/20k row test for that algorithm? I'm curious to see how it compared to the simple inline code above.

I like visio, but I don't typically use the automation tools. I've got a toolbar that I've built a few shapes into to help me with, but primarily I...

GilaMonster (10/14/2010)

---

Update:

He apparently...

WayneS (10/13/2010)

---

:hehe:

Which begs the question... how would you have...

Hmm... Would a cascading delete then be a very large boulder rolled along the library shelves? 😀

Heh, glad I ducked this one Wayne. http://www.sqlservercentral.com/Forums/Topic1003666-338-1.aspx

I think you were kinder then I would be at the end there.

David Portas (10/13/2010)

---

No it's not the same for the reasons I already stated: Constraints are standard SQL, unique indexes are not; Constraints are understood and used by more people; Some...

You're right, it was a bad example of...

David Portas (10/13/2010)

---

Stability is usually a desirable property for a key and is certainly an important consideration but it isn't an absolute requirement. Sometimes it may be quite reasonable to...

keith.gerritsen (10/13/2010)

---

This can get you:

abc def jkl mno ...

I bounce through a LOT of shops, and here's some average numbers I've seen at successful shops. Mind, this comes under the topic of 'What is a DBA' as...

Soulfly73 (10/13/2010)

---

I can make the selection on the columnnames cause they are different, but I don;t know how. With columnnames I mean the columnnames of the columns in the stagingtable....

He's going to need a self-referencing CTE for...

Quirky update is probably the cleanest way out of this, but it's not going to be pretty. I'd like to see your original DDL / proper sample data, please....

As mentioned, make it =0 instead of =1. I meant to switch it when I copy/pasted the code and forgot, sorry.

As Wayne mentioned above, the leap year is...