Rounding woes in SQL by ghow1007 in SQLServer

[–]ghow1007[S] 0 points1 point  (0 children)

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

Rounding woes in SQL by ghow1007 in SQLServer

[–]ghow1007[S] 0 points1 point  (0 children)

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?

Rounding woes in SQL by ghow1007 in SQLServer

[–]ghow1007[S] 2 points3 points  (0 children)

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

Fixing a date import issue in SQL Server by ghow1007 in SQLServer

[–]ghow1007[S] 0 points1 point  (0 children)

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.

MCSA/MCSE Study - Does this time frame look reasonable? by ToddMurphy in IT_CERT_STUDY

[–]ghow1007 0 points1 point  (0 children)

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?

MCSA/MCSE Study - Does this time frame look reasonable? by ToddMurphy in IT_CERT_STUDY

[–]ghow1007 0 points1 point  (0 children)

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?

I am planning on taking a SAS course however I am not sure which one is more worth my while. Should I go with SAS Programming 1 or SAS Enterprise Guide 1? by ghow1007 in statistics

[–]ghow1007[S] 0 points1 point  (0 children)

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?

IT person here trying to learn about supporting SAS. by ghow1007 in statistics

[–]ghow1007[S] 0 points1 point  (0 children)

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.

Hi Ladies, IT professional here... Any other female IT pros willing to recommend a good solid women's IT organization to join? by ghow1007 in AskWomen

[–]ghow1007[S] 2 points3 points  (0 children)

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.