ok, so if I have a system generated UID from a different table, but the values are not entirely unique, only a few duplicates in my heap, I could/should use...

Thought I'd tell you, you guys are just fun to watch. 😉

Sujizulu - this is a really old thread, try looking here, especially in the discussion surrounding the article:

http://www.sqlservercentral.com/columnists/jmoden/calculatingworkdays.asp

Article is specific to workdays in the US, but the lengthy discussion may...

Can't help but chime in to agree with the excellent advice above. Boils down to "do you really want to work for someone who is doing this?"

Which may only be...

The function we're using in-house is from Jeff Moden, whose Tally table article Nigel already pointed you to. Uses that to achieve Proper Case (aka Title Case)

http://www.sqlservercentral.com/Forums/Topic530630-8-2.aspx

Asking what is probably an obvious question, but from what I understand:

Adding a clustered index that covers multiple columns within a table is not necessarily advantageous, because it will expand...

Shoot, now I'm going to spend the rest of the week wondering just what category of white meat I fall into...

Thanks a lot...

Best answer I've ever seen: Because...

:hehe:

:hehe:

I'm confused, if we're talking about vines and clusters, shouldn't there be a bottle somewhere?

My first thought was "why the intermediate step, why not just replace double occurrences of space with nothing?", but after testing it, it obviously doesn't work because you don't know...

CirquedeSQLeil (11/12/2009)

Alvin Ramard (11/12/2009)

At first I thought you said...

How about a medical concern?

Foot In Mouth disease...

D'oh! Thanks for the correction, I was incorrect. Edited my previous post to indicate that, but left it in place so that your quote made sense in the context of...

ACK! Don't "Look Up" anything!!! :w00t: