I will want to have this solution in my arsenal. What is the code to install ACE Drivers? How do I set it up?

Please, show me easy and step by...

Probably a few more times. Is there anything I should be concerned about or something else I can do to improve the process?

Whooo!!!! That's what I was looking for! Thank you so much! Very helpful!

Thanks but for a newbie, I don't quite understand.

It would be helpful If you used demonstrative example with codes or processes that would help my cause.

Thank you.

I find this pointer (loading the data in a staging table) very immensely invaluable. But how do I do that? I am working off Server management studio, I have more...

Thanks a lot! This was really helpful. And your explanation clarified the code perfectly!

However, looking at the code (SELECT TotalHours = (SUM(CAST(PARSENAME(REPLACE(Trip_Duration,':','.'),2) AS INT))*60

+SUM(CAST(PARSENAME(REPLACE(Trip_Duration,':','.'),1) AS INT)))/60.0), what is the specific...

• This reply was modified 1 year, 8 months ago by  Teewhy.

yes

It is over  800,000 rows of data. So upon summation, the hours would be expected to run into thousands of hour.s

Secondly, the data was imported from excel in hh:mm format...

It is over  800,000 rows of data. So upon summation, the hours would be expected to run into thousands of hour.

Secondly, the data was imported from excel in hh:mm format...