What's the neater way to do this? I've got a data in a field 'foreignkey' in a particular table which is made up of various foreign keys delimited by '~' eg PLIE312~AP~347~212121~1~no I'm having ...

I'm writing a tool to bulk import log files (application activity logs). I've normalized my tables, but I can't figure out how BULK INSERT, OPENROWSET can work with normalized tables. For instance ...