Thank this author by sharing:
using values from variable length flat file in multiple rows
Get longest length of data in a column
Trying to get rows with same number of columns
Importing variable number of columns into a single sql table.
This script can be used to generate alter column length of any string data type column(s) in a datab...
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands
of articles and SQL scripts, a library of free eBooks, a weekly database news roundup,
a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals
that makes it such a success.