Column restriction

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Column restriction

Column restriction

Rate Topic

Display Mode

Topic Options

Author

Message

OnlyOneRJ

Posted Wednesday, December 12, 2012 4:47 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 09, 2013 9:02 AM
Points: 158, Visits: 443

I came acroos a problem shared by a developer in my firm,

He cretaes a SP & generates a report, now while doing this the columns of the reports are dynamically created & hence the max limit reaches upto 1024 columns..

But he wanted to add some more colimns in it.. how can this be solved w00t

Any help

************************************
Every Dog has a Tail !!!!!

Post #1395592

nigelrivett

Posted Wednesday, December 12, 2012 5:09 AM

Old Hand

Group: General Forum Members
Last Login: Monday, January 28, 2013 1:45 AM
Points: 386, Visits: 199

I would look at why you think you need more than 1024 columns in a report.

Cursors never.
DTS - only when needed and never to control.

Post #1395596

OnlyOneRJ

Posted Wednesday, December 12, 2012 5:19 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 09, 2013 9:02 AM
Points: 158, Visits: 443

Actually the information in the report which is required itself is more than 1024 columns...
how to get rid of this?

************************************
Every Dog has a Tail !!!!!

Post #1395598

Bhuvnesh

Posted Wednesday, December 12, 2012 5:25 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 8:41 AM
Points: 2,562, Visits: 3,451

you can maintain the column's list in dtaabase and fetch with the help of additional parameter (says reportID ) in stored proc. see below
table defintion (ColumnID, ColumnName , reportID)

table will have

1, 'EmpName' , 45 (reportID)
2, 'salary' , 45
etc

So NOw with the help of additional param in SP , you cna retrieve the column list and use in your dynamically.
column addition can be done in above whenever developer ask

-------Bhuvnesh----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post

Post #1395599

OnlyOneRJ

Posted Wednesday, December 12, 2012 5:29 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 09, 2013 9:02 AM
Points: 158, Visits: 443

bhuvnesh, u mean to say that by adding an additional parameters in sp we can extend the columns more than 1024?

************************************
Every Dog has a Tail !!!!!

Post #1395603

sgmunson

Posted Wednesday, December 12, 2012 2:03 PM

UDP Broadcaster

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 8:20 AM
Points: 1,446, Visits: 1,883

I think someone needs to rethink the idea that human beings are going to be able to make much use of a report with 1024 + columns. The idea that anyone could possibly need all 1,024 + all at the same time is absurd, unless they plan on subjecting that data to analysis in Excel or some other analysis tool, in which case maybe it's time to find out what the analysis needs to be and re-think what the report really needs to do. Maybe it should be an ETL process instead that loads a spreadsheet with the data, but a report with that many columns makes absolutely no sense at all.

Steve
(aka sgmunson)
Smile

Weight Loss Tips

Post #1395884

« Prev Topic | Next Topic »

Permissions