Doh :w00t: put the T2 column(s) at the front.

I keep biohazard emblems for all occasions. Sort of like online mood rings. You too can compile your own library if you just search google images...

Hey Jeff: Would you consider distributing it privately?

I believe that our DBA group prefers to simply have the views listed/flagged for review before changes are pushed to production. Apparently they prefer to control the sequence...

... and here it is in online help. It's a pain to have to drop all views before you can alter a table, but it prevents situations like...

Hey Seth:

I was able to duplicate your problem in my sandbox db and found that simply doing an ALTER VIEW with the original specs from your CREATE VIEW...

Tell me about the locks, Clarice....

EXACTLY !! 🙂

Comparison? How can you infer that?

Heavens no, I would NEVER think of making such a comparison. :hehe:

I agree with Barry 100%...

HERESY!!! :w00t:

Everybody down South knows you should deep-fry those suckers and serve 'em with come-back sauce. (They'd go well with...

A modest proposal... :w00t:

I am not able to identify where the problem is, whether in the application coding or in the client machines or in the server ( the server is having...

Duplicate posting. It was answered here:

http://www.sqlservercentral.com/Forums/Topic633424-338-1.aspx

Yes, and the "sample data" doesn't have any column resembling an ID to designate who "they" are that can order "any number on this combination."