In that case, some sort of mapping would need to be done, either by a person at runtime, or by a mapping datastore of some sort. Yeah, that makes...

The easiest way I know of to do that would be to join to the phone number table twice, instead of having an "IN" statement. First instance would pull...

That will be from the Year + 1 that...

Are there rules about the values in the int columns?

For example:

CREATE TABLE #T

(ID INT IDENTITY

...

DSR0308 (5/4/2011)

---

Unfortunately it did not.

I think its my fault of not explainning myself properly.

I truly appreciate all the help.

Ill give it one more try.

I have a datawarehouse that loads once...

calvo (5/4/2011)

---

Ninja's_RGR'us (5/4/2011)

---

Then it's the "parental" culture. The bottom line is that he feels offended and that you don't want to offend him. Just learn to get along.

No...

I can't see that you'd have to build a separate metadata store, since sys.columns, sys.tables, et al, should allow for dynamic Merge statements to be built. However, it's going...

Here's what Microsoft says on it:

CHECKSUM satisfies the properties of a hash function: CHECKSUM applied over any two lists of expressions returns the same value if the corresponding elements of...

I was wrong.

I just tried installing a new instance, and when I went to name the instance, it stopped letting me type when I got as far as "MyInstanceNameIs". ...

Here's Microsoft's data on max-whatever in SQL Server. The one you want is the "Max Identifier Length", if I'm not mistaken.

http://msdn.microsoft.com/en-us/library/ms143432.aspx

I haven't tested instance-name length, but it should follow...

There isn't a single set of rules on that.

Some places, the .NET devs can't put anything in the databases without approval from the DBA. Others, the DBA just helps...

It's not a question of English or grammar. Either is grammatically correct.

Manners are, essentially, a question of granting beingness/importance to the other, and following locally recognized customs. The...

You can tell Management Studio to connect to Visual Source Safe or Team Foundation Server, so I think you can connect it to other forms of source control. Check...

You need to join the query to itself.

There may be a better way to do it than this, but this should work. You know more about the tables than...

XML and HTML both read the code for the same way, so the forum is doing that to you. Using the "Quote" button on your posts shows what you...