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.

All Forums  SQL Server 2005 Forums  SSIS and Import/Export (2005)  Dynamic columns

Author  Topic  Dev@nlkss 134 Posts Posted - 2009-04-01 : 00:59:00 In one of my tables i have a location column and it contains variable number of "Properties" for that column. Then i have to build a new table for every location as all the "Properties" becomes as columns of new table. Each Property Item size of nvarchar(255) but we have a limitation "Bytes per row of 8060" where in my case it may exceed. Is this the right way which am following? or Is there any other way for this kind of situations? Its really urgent Thanks for any help. $atya. Love All Serve All.