|
Anyone know SQL server that can help me with a query?
Posted 1/6/2011 7:35:02 PM by luvsun27 I have a table that I created by importing a tab file. There are different record types in the source file (header, line, discount, etc, etc). Each record type has a different amount of columns. The longest record type has 22 columns, so the table was created with 22 columns (I just used the import text wizard). Anyway...I want to export the data to a file, but I need each record to only have the number of columns that are valid, and not 22 columns for each record type. So, header record is 15 columns, line record is 10, etc, etc. Is there a different way to import this file that would help me get the results I need? Any idea on how to write the syntax of the query to get this data? If you can help...please let me know. Thanks! |