I ported an Informix table into my SQL Server 7 database. This table was constructed with 358 columns. SQL Server did not complain but, the creator of this gigantic table wants to have an access front-end. When I tried linking this table over it didn't surprise me that Access would only view or link over 256 columns...
My question is, how would I split this table up in SQL Server, or will a pass through query work OK..
any good suggestions on SQL Server programming books.