Viewing 15 posts - 1 through 15 (of 38 total)
Thanks again for all your help. Did the sample look ok?
July 30, 2020 at 7:00 pm
It seemed to work if I change the rowterminator to below. Does the sample look right?
,ROWTERMINATOR = '0x0a'
July 30, 2020 at 3:45 pm
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.
July 30, 2020 at 3:16 pm
Thanks. For the powershell part, do I need to modify it for my PC or what do I need to do?
July 30, 2020 at 1:23 pm
I'm still getting an error message when doing a bulk insert. Any ideas?
July 29, 2020 at 6:44 pm
Sorry that guy had one of my post removed. He is a freelancer and well known on sql central
July 7, 2020 at 7:27 pm
I've uploaded my code? Did you read it?
June 29, 2020 at 7:57 pm
It won't load all of the data. Get an error. I'm trying to do a bulk insert.
June 29, 2020 at 7:20 pm
Thanks. Is there a way for the total to not be in a separate column and be in the count column instead?
April 24, 2020 at 7:25 pm
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...
April 20, 2020 at 12:43 pm
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...
April 17, 2020 at 7:01 pm
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...
April 17, 2020 at 5:47 pm
I thought i had it attached in the original post?
April 17, 2020 at 2:51 pm
That removes the row though. I want to keep the row but not have it included in the total.
April 17, 2020 at 12:41 pm
Would this work to only have to hit run and it would import and create the table?
if object_id('DE_IDENTIFIED.dbo.test') is not nulldrop table DE_IDENTIFIED.dbo.testif object_id('DE_IDENTIFIED.dbo.PROVIDER_INFO_1') is not nulldrop...
April 13, 2020 at 6:28 pm