Well it sounds like ultimately you are loading it into a SQL table.  So you can either filter out the fields you don't care about when reading the file or...

When you're pulling the records out of the array to do the inserts you should be able to just pull the fields you need.

At this point without seeing the real file and given...

Well this should get you an array with all the records in it in a PSObject format, from there you would need to go through it build your insert statements.

It amazing how many people don't...

This is something where the question itself is kind of nonsensical, like what is better eating a steak or watching a good TV show.  There might be some...

This is something where the question itself is kind of nonsensical, like what is better eating a steak or watching a good TV show.  There might be some overlap between...

There's no left join in that query.

Take a look at the execution plan. It's going to be all one allocation.

UNION ALL isn't a bad performer in general. In fact, usually, you get better performance with...

This is one that would be nice to be able to do at the session level.

It comes up where someone might want to use a different collation for a number...

Brute force works if the protected system allows an unlimited number of retries, no time restrictions on subsequent attempts (see iPhone), and no alerts to the genuine user...

Good editorial, Steve. NIH Syndrome is extraordinarily strong where I work. I appreciate the link you gave to the Wikipedia article on it. I've never seen such a strong...

Heh, that's apparently very easy but chrome at least very correctly detects it and blocks it 😛

• This reply was modified 3 years, 6 months ago by ZZartin.
• This reply was modified 3 years, 6 months ago by ZZartin.
• This reply was modified 3 years, 6 months ago by ZZartin.

I don't believe windows will do split zip files natively so you would need to download some other program to do it.  7-zip does have a command line so that...

Well that entirely depends on your data 🙂