Posted by Erland Sommarskog on 03/21/06 16:57

Jens (Jens@sqlserver2005.de) writes:
> If the only reason is to get the data in QA the right way, why don´t
> you craete a view for each table suing *your* selection order as you
> are prefering to it. Although some flavour of displaying data are the
> same, it is truly possible that the one developer want to see the
> columns in the the colum1,column2, column3..column32 and another one
> want to see col
> column32..colum1,column2, column3. Who will decide what sort is *right*
> by default ?

We have 800 tables in the database. Are you seriously suggesting that
we should add 800 views only because it's difficult to change column
order? That is definitely not going to make developers less confused.

> First of all, thanks for the polite and detailed explanation in the
> first sentence. :-) As I already said, only because some people are
> voting for something, that doesn´t always mean that this is useful.

Of course, it does not mean that it is useful to you. But just because
it's not useful to you, there is no reason to try to cram down your
opinion down their throats. It's not at all helpful to tell people
"you don't need that". If you believe that Surya could solve this under-
lying problem in a better way, you could ask for the reason, to be
able to address the problem. But dismissing his question out of hand
is just plain insincere and about as impolite as my response.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]