I have a table of multiple URLs to one ID…the table has about 1.5 million rows. I’m trying to pivot the data so that each column is URL 1, URL 2, URL 3 and on…so I have one row for each ID.
When I try to do a pivot it tells me that my table is to big, there is a 100,000 row limit. Anyone know of any other way to do this?