Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
oahu9872
Posting Yak Master
112 Posts |
 Posted - 2007-11-14 : 14:51:33
|
| I am working on a report split into 2 Excel spreadsheets because it is roughtly 350 columns wide. I know this exceeds the MS Access column limit, but is there a way to build this in a single table in SQL Server? If not, does anyone have any ideas. Thanks |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-11-14 : 15:33:51
|
| you can have a mx of 4,096 columns in a select statement in sql server_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
 |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2007-11-14 : 16:00:49
|
Shouldn't be an issue at all for SQL table, 8060 byte limit..but a database used at our place as a table with over 900 columns. (I had nothing to do with that one!)
Poor planning on your part does not constitute an emergency on my part. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-14 : 22:40:14
|
| Base table can have up to 1024 columns. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-11-19 : 02:07:57
|
| Read about Maximum Capacity Specifications in sql server help fileMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Column Limit