Find Jobs
Hire Freelancers

SQL Assistance

$10-30 USD

Closed
Posted almost 10 years ago

$10-30 USD

Paid on delivery
Hello, using sql 2008, trying to convert a string to int Example Table1 has a varchar which i want to cast to int 00125000000 to int 125000000 i used the following cast(B.[Assessment] as int) as [USER1_01], with the result 125000000 Table2 has the same field in a different format. 0.00125 i need to find a way to convert one of them so they both match. if i did a join and matched the fields. I tried cast (10000000000 * cast([USER1_01] as NUMERIC(6,6)) as INT) as [USER1_01] but for some reason it dosent look like they match, although they look the same. maybe a type problem?. I hope someone can shed some help me, been working on this for a long time :(
Project ID: 6174284

About the project

19 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
19 freelancers are bidding on average $20 USD for this job
User Avatar
Dear Sir, Please execute following statements you will get the output as required . SELECT CAST( cast('0.00125' as DECIMAL (10,10))* 10000000000 AS DECIMAL) as [USER1_01] ; SELECT CAST( cast(B.[Assessment] as DECIMAL (10,10))* 10000000000 AS DECIMAL) as [USER1_01] ; -- Pay me 10$ :-) I'm very much familiar with MS SQL Server ( SSIS SSAS SSRS) and also during last five years I involved many project in ETL, data warehousing, BI reporting and six years of application development experience. I would highly appreciate if you assign this job to me and also I'm Microsoft Certified Technology Specialist (MCTS) for Microsoft SQL Server 2008 for Business Intelligence Development and Maintenance & Microsoft Office SharePoint Server Application Development. Please reply me for further details Best Regards, Jinesh
$15 USD in 1 day
4.9 (69 reviews)
5.7
5.7
User Avatar
Hello Sir/Madam, I hope you are having an easy week. My name is Milan Sahu from Kolkata, India. I am a .NET C# SQl SERVER Developer. I am willing to do your project. I checked your requirement and i want to work with you. I am interested in a long term relationship with you. Waiting for a positive reply. Thnkz & regards Milan Sahu, kolkata, India
$30 USD in 1 day
5.0 (10 reviews)
4.7
4.7
User Avatar
I can help you to resolve this issue. I have strong skill in DBA (SQL Server, Oracle, MySQL). Let discuss about it in more detail.
$24 USD in 1 day
5.0 (7 reviews)
4.3
4.3
User Avatar
Hello, I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server databases, i have more than 8 years of experience working around databases and SQL development around (SQL Server ,Mysql ,Oracle ) . My last job was database consultant within Accenture ,for more than 4 years .I worked for several database projects and advanced SQL development on behalf of European Customers (Carrefour, LOREAL,Eurovia ..). I have strong skills in database development and SQL to develop all types of requirements related ,and given my experience, I am persuaded to give you High quality of work delivery withing budget and time Best regards,
$29 USD in 0 day
4.8 (13 reviews)
4.4
4.4
User Avatar
Hello sir, I have solved your query. For both there is a single query . So please give me personal message so i can show you this query with results. Thank you
$13 USD in 1 day
5.0 (5 reviews)
4.2
4.2
User Avatar
Let me help you with this task. I have using SQL Server 2008 R2 for over five years. Waiting for your award. Thanks
$30 USD in 1 day
4.9 (7 reviews)
2.6
2.6
User Avatar
Hi, Let me try to convert to match both field. I am looking forward to hearing from you. Thanks, Minh Thang
$20 USD in 1 day
5.0 (1 review)
2.3
2.3
User Avatar
A proposal has not yet been provided
$27 USD in 1 day
5.0 (2 reviews)
1.9
1.9
User Avatar
Hello, Could you provide samples from both tables as db so I can attach them and find the solution for you. I'm a SQL DB admin with great experience and would like to help you in your task. Best regards, Tony
$10 USD in 1 day
5.0 (1 review)
1.0
1.0
User Avatar
Hi.. Can u explain me again by chat regarding your sql server query... So I can try for that.........................
$15 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
HI, I am Kapil Jain from India and I would like to apply for this job profile as I meet all your Job requirements. Why Hire Me 1.) Highly dedicated and experienced programmer 2.) Over 2 years of experience working as Oracle developer with prominent IT organizations in India (HCL Technologies Pvt. Ltd., Prisio Technologies Pvt. Ltd.) 3.) Quality deliverance within stipulated time frame 4.) Highly competitive fee charges We can share screens (via team viewer) or we can have discussion over skype. Please do let em know if you find me suitable for this job profile, as I will be able to help you in this task. Regards, Kapil Jain
$16 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
hello dear Customer. I have alredy existing solution for you. Soluion: cast(replace(B.[Assessment], '.', '') as int) as [USER1_01], If you like hope to get please paid for my work
$10 USD in 0 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I believe I am well qualified for this task due to my being a Microsoft Certified Database Developer and a Microsoft Certified Technical Specialist for SQL. Also, I have already figured out the answer to your problem (you need to multiply by 100000000000 rather than 10000000000 . . . i.e you're off by one zero). I figure it is probably worth the amount of my bid if you are looking for the solution. ;-)
$10 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I'm a french software engineer and I'm ready to help for your project. Since 2006 I work on Databases (Oracle, MySQL, SQL Server, Access and Ingres). If you have any questions, please send me a message. Best regards, SmartNG
$22 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi there, I write complex SQL on a daily basis, and from the example you've given think I may have already cracked the issue. All the best Stu
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$21 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of CANADA
Brighton, Canada
4.9
26
Payment method verified
Member since Mar 2, 2008

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.