Jeff Moden (3/17/2015)

---

Resolving this issue is actually pretty easy but I need some data to work with. Any chance of you attaching a file that I can test with...

Attached is a smaller version of the file that I'm using. I opened it in notepad++, edited it and saved it as a .txt file so I could upload...

I'm still trying to figure out how to make this data into columns. Is it not possible with "DelimitedSplit8K"? Should I use something else? Is there something...

@Ed Wagner

your code example makes the data into rows, not columns. How do I use this to make columns?

So, my other option. If I just import the file into one columnCREATE TABLE BULKACT(RAWDATA VARCHAR (MAX))

BULK INSERT BULKACT FROM 'C:\ftp\NAV830.curr' then I can only import the rows where...

Lowell (3/11/2015)

---

ok , the issue is this is one of those file swhere there's layers of data;

three from your screenshot:

OHD record

HDR record

DTL record(s) that are related to the HDR row...

How do I "fill up your shorter lines with extra field terminators so every row has 18 columns"?

Another alternative I was thinking was to import all of this data into...

Okay so now that I figured out how to add images I edited my last post. Please look it over and let me know what I'm missing.

That screenshot is exactly what notepad++ shows for my file "CRLF" but when I tried \r it didn't work. Maybe there's something more in my process or maybe I'm...

Great! I changed varchar(100) to varchar(1000) and it works without errors but I'm still not finding the rowterminator. I've tried

\r

\r

\r

char(10)

0x0a

and none of them seem to be able...

Okay so I'm running the following code to import my asterisk delimited file.

/* CREATE TEMP TABLE */

IF OBJECT_ID('tempdb..#tblhdr830') IS NOT NULL DROP TABLE #tblhdr830

CREATE TABLE #tblhdr830(A1 varchar (max) not null

...

@ Ed Wagner

That's my point, it's too huge to recover to another database just for one table. It would take forever. I have about 80% of...

bump

Does my post make sense? Is this a possibility? How can I bring over the selects that are selected but only if not all are selected?

Bump

I'm still looking to see if there's a way to repeat the headers of the table for every Group? Is this possible?

Ville-Pekka Vahteala (8/28/2014)

---

If I understand you correctly this should be quite easy.

I understood that you want to have second detail row for val5 for each detail row. If this is...