They have office installed because this place uses the server like a big desktop. The faster one has a Local Disk C drive and a DATA D drive. The slower...

File is in a folder on C drive for both. How do I configure the drives and compare performane? Sorry, I'm not a dba at all and got handed this...

• This reply was modified 4 years ago by  smattiko83.

Thanks again for all your help. Did the sample look ok?

It seemed to work if I change the rowterminator to below. Does the sample look right?

,ROWTERMINATOR = '0x0a'

• This reply was modified 4 years, 4 months ago by  smattiko83.

It still didn't work without the powershell. Is the attached what I need to do for the powershell? It doesn't seem to do anything.

Thanks. For the powershell part, do I need to modify it for my PC or what do I need to do?

I'm still getting an error message when doing a bulk insert. Any ideas?

Sorry that guy had one of my post removed. He is a freelancer and well known on sql central

I'm getting:

• data conversion error(truncation)
• OLE db provider "Bulk" for linked server...

I've uploaded my code? Did you read it?

It won't load all of the data. Get an error. I'm trying to do a bulk insert.

• This reply was modified 4 years, 5 months ago by  smattiko83.

Thanks. Is there a way for the total to not be in a separate column and be in the count column instead?

That is it! Thank you!

I wish I did not have to sort this way or sum the two rows but was told they have been looking at it this way...

The second null went away with the change in the group by. Is there a way to sort and still have the total by parent/category description at the bottom every...

• This reply was modified 4 years, 8 months ago by  smattiko83.
• This reply was modified 4 years, 8 months ago by  smattiko83.

It is close. I had to change the second query below or it had another Null like in the screen shot. The only issue now is the order. The Total...

• This reply was modified 4 years, 8 months ago by  smattiko83.
• This reply was modified 4 years, 8 months ago by  smattiko83.

I thought i had it attached in the original post?