sravan.here (4/19/2013)
Yes there are tables with 4 or 5 or more columns as well as you doubted.I have just provide a simple example here.
But the maximum column names (with csv) will be 26 in the meta file / table.
I am just looking for a way to create tables on the fly.
How do you identify which rows go into which tables? With your sample data it's easy - two tables. A larger and more realistic sample data set would be very useful.
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden