Thanks for the reply.

That helps

Thank you

I agree, thank you, Steve.

okay thanks, I appreciate your advice here.

thanks for the reply, but I was looking for some key things that I could tell management that it is better to go to 2019 over 2017.

Thank you

Okay,

Thanks for your help

Hi

First, thanks for the reply, I like the CTE here.

Unfortunately, I need this to be in one statement like this:

SELECT rr.[company_name],
(CAST((Count(rr.[company_name]) + 1)  AS decimal(10,2))/NULLIF(CAST((Count(rr.[company_name]) +...

Thanks for the reply.

I am not sure what happened but yesterday it would not let me import it, but today on another machine it did.

I will look into splitting it...

Hi,

Thanks that did it.

Thank you

thank you

That is what I have and I did look it up and it said that using 100 or 101 should give me mm/dd/yyyy format. and it is working but I...

Okay thanks

I appreciate your help

Yes, but more to the point I wanted to know if what I proposed would import the data without the line feed?

Or how can I do that?

Thank you

Update,

I thought that the fields were out of place but they are okay. One field now is having a problem, and I am looking at that now.

But I would like...

Hi,

I am sorry if you are getting this twice now, I replyed twice and I am not seeing it here; so I am trying again.

First I did not have the...

Thanks for the reply. I guess you would say the menue. He is using the Import Export wizard.

Thank you