|
|
Posted by panic attack on 08/04/06 08:07
ofcourse it has 543 columns :)))
the data includes records for about 6 years, 20 quarters and 60 months
back data and for each period it has 6 parameters and some other
columns info(text).
so if you do the math;
(6 * 6) + ( 20 * 6 ) + ( 60 * 6 ) = 516 columns.
and if you add the other columns the result is 543
as i said i tried various types to get the data in to SQL
nvarchar , varchar , ntext etc.
but none of them worked out.
what do you think Erland? do we have a chance to get over this problem?
or it is not possible to get the data into SQL Server 2000?
NOTE : By the way there is another data that we are importing to Sql
Server 2000.
and it has 124 columns. no problems occur while getting the data into
Sql Server 2000. if we apply the same logic as you did ,
124 * 255 = 31620
so it is also bigger than 8060. but we are doing the operation without
any problems.
it seems that there is a contradiction doesnt it?
what about SQL Server 2005? is there any limitation at sql server 2005
about the row size?
Tunc
Erland Sommarskog wrote:
> panic attack (tunc.ovacik@gmail.com) writes:
> > CREATE TABLE [nwind].[dbo].[DDD] (
> > [Col001] varchar (255) NULL,
> > [Col002] varchar (255) NULL,
> > [Col003] varchar (255) NULL,
> >...
> > [Col543] varchar (255) NULL
> > )
>
> The table appears somewhat funny. Does the table really reflect your
> business rules? 255 * 543 is 138465 and with a maximum row size of
> 8060 in SQL Server, this is not like to turn out well.
>
> > i also tried "nvarchar" , "ntext" ect. but none of them worked. :((
>
> If you tried 543 ntext columns, I can understand why that fails. A ntext
> column has a 16-byte point which is in the the row, and the real data is
> elsewhere. 543 * 16 is 8688, so you can't have all those text pointers
> on a single row.
>
> Does your input file really have 543 input fields?
>
>
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|