I have a SSIS package that will get data from Text to Table xyz_raw ... Now i need to use the XYZ_RAW table and write an SP to Parse into XYZ_Formatted.well i got the sp ... But one of the column in XYZ_RAW is log_INFO VARCHAR(500). Which have a rows like: Inserted / Log ICode Action on Order Number / 33949591 / with / I-Code / IDEC/ / Memo: / cci questions about alert/ Inserted / Log ICode Action on Order Number / 18092925 / with / I-Code / IDEC/ / Memo: / ?? regarding program/ ..... about 25 columns I need to use this or take this column's ROWS from XYZ_RAW use my sp to dump it into XYZ_Formatted .. I was confused and asked my manager how he needs me to insert he said use 3NF USE 3Normal Form ............ can u guys help me how can i insert : from XYZ_RAW to XYZ_Formatted ..... Thanks

suspect he just means to create lookup tables for the attribute column data. So take all of the columns in turn and insert distinct values into a lookup table with an identity for entries that aren't already there Then take the raw table an join to the lookup tables and insert the IDs and any non-lookup data into columns in the destination. Should mean that it takes up a lot less space and is faster to access.

what i got the info is to split the column : Inserted / Log ICode Action on Order Number / 33949591 / with / I-Code / IDEC/ / Memo: / cci questions about alert/ like for example : colmn1 column2 column3 Inserted with I-Code IDEC Log ICode Action on Order Number 33949591 Memo: cci questions about alert Inserted with I-Code IDEC Log ICode Action on Order Number 18092925 Memo ?? regarding program something like that ..... the destination yable columns shud be the above ...how can i split ..it should work for millions of records

Are these / seperated columns? If so then probably the easiest is to use SSIS or bulk insert specifying the separator. If you want it in sql it depends on the power of the server and how much data there is - you can use a cte to search for the separator. Batch it into 10000 rows at a time if necessary.