[AccessD] SQL Question

Martin,

>From your comments I gather that your Windows security folks do not know
anything about database design or programming.  So why are they allowed
to dictate how your data is supposed to look?  I know you work for a
bureaucracy like I do, but that doesn't in and of itself mean that they
all are stupid and unable to comprehend a rational argument for doing it
some other way.

Charles Wortz
Software Development Division
Texas Education Agency
1701 N. Congress Ave
Austin, TX 78701-1494
512-463-9493
CWortz at tea.state.tx.us



-----Original Message-----
From: Mwp.Reid at Queens-Belfast.AC.UK
[mailto:Mwp.Reid at Queens-Belfast.AC.UK] 
Sent: Tuesday 2003 Jun 24 13:24
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] SQL Question

We have no control over the source and thats the way it is.

We are bulding an SQL database to work with Windows security. We have to
get 
our data into a single table. 

One of those jobs that just has to be done the way the security guys
want it.

Martin


Quoting "Heenan, Lambert" <Lambert.Heenan at AIG.com>:

> Well to get the data laid out the way you suggest should only need a 
> simple Cross Tab query, but (like everyone else) I have to ask "Why?" 
> It looks like
> your two source tables have nicely normalized the data, but now you
> (or
> whoever is doing this HR thing) want to un-normalize it.
> 
> Also, why does the act of linking to another system require that you 
> build this un-normalized table / query to work with it???
> 
> Lambert