Home Forums SQL Server 2008 SQL Server Newbies read multiple fields with common delimited data into either a temp table or table variable without using cursors RE: read multiple fields with common delimited data into either a temp table or table variable without using cursors

  • That's fine Sean, I've done the same myself. As for my problem, although your solution looks good and as it stands would work with my table, I've put the amount of fields as 4 but in reality it stands at 12 and could grow in the future. Is there some kind of dynamic way I can search across the fields?