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 |
|
ricky_1605
Starting Member
30 Posts |
 Posted - 2010-11-01 : 05:41:39
|
| Hey guysI have a table with 150 columns. This table contains data of 10 locations. Now i am making a report in which data of all the locations has to be shown i.e. 1500 columns. As it is a crystal report i have to take the value of each column of each location in a different variable. Please help.Nipun Chawla |
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-11-01 : 07:06:45
|
| So what is the problem?PBUH |
 |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2010-11-01 : 13:40:00
|
| http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx |
|
|
|
ricky_1605
Starting Member
30 Posts |
Posted - 2010-11-02 : 06:40:09
|
| The problem is that the limit of a table is 1024 columns in sql server. What should i do?Nipun Chawla |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2010-11-02 : 11:53:46
|
| Return the data to crystal reports from a SELECT query.SELECT statements have a limit of 4,096 cloumns.CODO ERGO SUM |
|
|
|
|
|
|
dynamic table with 1500 columns