Viewing 15 posts - 16 through 30 (of 49 total)
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
I'm getting:
July 7, 2020 at 7:27 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 null
drop table DE_IDENTIFIED.dbo.test
if object_id('DE_IDENTIFIED.dbo.PROVIDER_INFO_1') is not null
drop...
April 13, 2020 at 6:28 pm
Cool, it seems to work well. Two questions.
April 13, 2020 at 4:57 pm
create table de_identified.dbo.test
(recordtype varchar(3)
,record varchar(500)
)
BULK INSERT de_identified.dbo.test FROM 'C:\dident\PRV414WSW\PRV414SW.txt'
April 13, 2020 at 3:50 pm
I get the following error:
Msg 4866, Level 16, State 1, Line 8
The bulk load failed. The column is too long in the data file for row 1, column 1. Verify...
April 13, 2020 at 3:28 pm
Do I just replace the part he has the select and from with a bulk insert?
April 13, 2020 at 3:03 pm
Viewing 15 posts - 16 through 30 (of 49 total)