"Jeff Swanberg" <j_swanberg@msn.com> wrote in message
news:eXkZLfbHIHA.5328@TK2MSFTNGP05.phx.gbl...
> Using SQL Server 2K
>
> TableA with two columns:
> StudentID Int (PK)
> ATTENDANCE char(7000)
>
> TableB has seven columns:
> StudentID Int
> ATTEND1 varchar(254)
> ATTEND2 varchar(254)
> ATTEND3 varchar(254)
> ATTEND4 varchar(254)
> ATTEND5 varchar(254)
> ATTEND6 varchar(254)
>
> I want to insert into TableA a single entry from a concatenation of
> TableB:
>
> INSERT INTO TableA
> select
> StudentID, (ATTEND1+ATTEND2+ATTEND3+ATTEND4+ATTEND5+ATTEND6) as ATTENDANCE
> from
> TableB
>
> This only works in Query Analyzer, though, if I go to
> Tools-Options-Results and change the "Maximum characters per column" value
> to 7000. If I don't, then the only value that gets put into TableA's
> ATTENDANCE column is the first 256 characters of the concatenation.
>
> I would like to run this in a DTS package or Stored Procedure and I'm not
> sure how to make that same maximum character change programmatically.
>
> Jeff
>

"Mark J. McGinty" <mmcginty@spamfromyou.com> wrote in message
news:eeqLOJdHIHA.1212@TK2MSFTNGP05.phx.gbl...
> (Expressly avoiding discussion of your design...) why don't you just
> define a computed column on TableB? Then you can skip the need to keep it
> updated, it will always be current. One possible drawback, if you're
> using any SELECT * queries, is that the addition of the computed column
> might blow out the 8060 limit, but since you really should avoid that
> anyway...
>
> Just a thought,
> Mark
>
>
> "Jeff Swanberg" <j_swanberg@msn.com> wrote in message
> news:eXkZLfbHIHA.5328@TK2MSFTNGP05.phx.gbl...
>> Using SQL Server 2K
>>
>> TableA with two columns:
>> StudentID Int (PK)
>> ATTENDANCE char(7000)
>>
>> TableB has seven columns:
>> StudentID Int
>> ATTEND1 varchar(254)
>> ATTEND2 varchar(254)
>> ATTEND3 varchar(254)
>> ATTEND4 varchar(254)
>> ATTEND5 varchar(254)
>> ATTEND6 varchar(254)
>>
>> I want to insert into TableA a single entry from a concatenation of
>> TableB:
>>
>> INSERT INTO TableA
>> select
>> StudentID, (ATTEND1+ATTEND2+ATTEND3+ATTEND4+ATTEND5+ATTEND6) as
>> ATTENDANCE
>> from
>> TableB
>>
>> This only works in Query Analyzer, though, if I go to
>> Tools-Options-Results and change the "Maximum characters per column"
>> value to 7000. If I don't, then the only value that gets put into
>> TableA's ATTENDANCE column is the first 256 characters of the
>> concatenation.
>>
>> I would like to run this in a DTS package or Stored Procedure and I'm not
>> sure how to make that same maximum character change programmatically.
>>
>> Jeff
>>
>
>

> This only works in Query Analyzer, though, if I go to
> Tools-Options-Results and change the "Maximum characters per column"
> value to 7000. If I don't, then the only value that gets put into
> TableA's ATTENDANCE column is the first 256 characters of the
> concatenation.
>
> I would like to run this in a DTS package or Stored Procedure and I'm not
> sure how to make that same maximum character change programmatically.