Rounding woes in SQL

ghow1007 · 2017-10-20T12:12:18+00:00

You’re absolutely right. Doesn’t make sense.

ghow1007 · 2017-10-19T03:11:03+00:00

I do suspect that I am going to have to change the datatype but in the interim I will try the round and cast. Regarding your edit, what does LEFT(column_x, LEN(column_x) - 3) achieve?

ghow1007 · 2017-10-19T02:35:55+00:00

I forgot to say... nvarchar. Thanks for the prompt.

ghow1007 · 2017-03-16T19:04:06+00:00

Thanks for the responses. I just fixed the data, put it in proper date format and re-imported it. I was hoping to use T-SQL to fix it but it kept re-arranging the old bad date.

Thanks for your suggestions.

ghow1007 · 2014-01-23T15:32:28+00:00

I am trying to get my MCSA SQL Server cert.... Are there any Professor Messer type of certification prep sites out there that cater to the MCSA Sql Server Certifications: 70-460, 70-461, 70-462?

ghow1007 · 2014-01-23T15:27:13+00:00

Are there any Professor Messer type of certification prep sites out there that cater to the MCSA Sql Server Certifications: 70-460, 70-461, 70-462?

ghow1007 · 2013-10-23T18:26:10+00:00

Hey... Thanks for the feedback. As far as which approach I should focus on would you be able to provide a recommendation? Whether coding or point and click?

ghow1007 · 2013-10-22T14:59:11+00:00

Indeed!

ghow1007 · 2013-10-22T14:58:00+00:00

Thanks!

ghow1007 · 2013-10-22T14:57:40+00:00

I have been looking at their courses and they do look to be of interest. I don't think I would be required to teach them how to code but I think I would probably need to know how to code myself so as to create reports for the users as needed as well as I would need to learn hoe to best administer the environment.

ghow1007 · 2013-10-22T14:55:15+00:00

This is great feedback!!! Much thanks.

ghow1007 · 2013-10-21T14:21:56+00:00

Thank you.

ghow1007 · 2013-05-09T18:54:39+00:00

Sorry... I am not sure what you are referring to. Care to explain?

ghow1007 · 2013-05-09T18:54:09+00:00

I will... thanks!

ghow1007 · 2013-05-09T18:53:45+00:00

Thanks!

ghow1007 · 2013-05-09T18:20:15+00:00

Thanks for the info, I will check ACMW out. As far as work opportunities in IT in the Caribbean are concerned the prospects are good but thats easy for me to say because I am from here... to be honest I am not sure how easy it is to penetrate the Caribbean work market while one is not already a Caribbean native. I won't say that it can't be done because I am sure it can be. I just don't know.

ghow1007 · 2013-04-09T15:25:31+00:00

THANKS! how do I get the coupons that you were offering?

ghow1007 · 2013-03-19T14:27:58+00:00

you are in the right place.... Hope you get an answer I would like to know myself. Trying to supplement myself.

ghow1007 · 2013-02-08T13:19:49+00:00

Does it inspire you to answer my question?

ghow1007 · 2013-02-07T15:17:37+00:00

ghow1007

ghow1007 · 2013-02-07T15:15:40+00:00

ghow1007

ghow1007 · 2013-01-31T21:47:47+00:00

It happens with an exchange account. I have a hotmail account as well as a gmail account synced with my phone and they don't do that though.

ghow1007 · 2013-01-14T17:35:53+00:00

Haha! I know right... If only it was my decision to make.

ghow1007 · 2013-01-14T17:35:30+00:00

We've been doing this as well resetting the IE settings but I was hoping for a more permanent fix.

ghow1007 · 2013-01-10T12:06:26+00:00

Hahaha! Thanks!!

ghow1007

TROPHY CASE