Find Jobs
Hire Freelancers

Query building in MSSQL - split result in different values

€8-30 EUR

In Progress
Posted over 1 year ago

€8-30 EUR

Paid on delivery
Hi, My actual Query: +++++++++++++++++++++++++++++++++++++++++++++++ SELECT * FROM [login to view URL] WHERE lgcode = '93442/52/31' +++++++++++++++++++++++++++++++++++++++++++++++ THE RESULT IS: R35SU.24.830.01-21 (FINE!) +++++++++++++++++++++++++++++++++++++++++++++++ My target is to split this results as other fields by this way. Value1= R35SU (always5 characters -text-) value2= 24 (always 2 characters -text-) value3= 830 (It can be also 2 characters -text-) value4= 01 (It can be also 3 characters -text-) Value5= 21 (always 2 characters -text-) Who can split this Query? FTP or Database access not allowed. I'm looking just for the Query. Thanks in advance.
Project ID: 35923607

About the project

22 proposals
Remote project
Active 1 yr 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
Awarded to:
User Avatar
does LGDOXISCODE table only only one field? what is the field name? I can use string split method to split base on the delimiter , and use as keyword to assign as the field you want
€19 EUR in 1 day
0.0 (0 reviews)
0.0
0.0
22 freelancers are bidding on average €23 EUR for this job
User Avatar
Work on this field more than 20 years and have high experience so can introduce great work and fast deliver so need to talk for more details about the project
€19 EUR in 2 days
4.9 (55 reviews)
6.0
6.0
User Avatar
UPDATED. ALREADY SOLVED JUST PING ME FOR INSTANT RESULT. HEllo. It's all about string split. can be done quickly from provided description. Please ping me if interested to have it done right now. Best regards, Siarhei.
€19 EUR in 1 day
4.9 (8 reviews)
5.5
5.5
User Avatar
Hi In my current Profession -I perfom the DBA and Developer duties in high traffic OLTP environment -Data Mining ,Data Science,Machine Learning -Python programing -data analysis using python and R -Data Scraping using python, -Database development in (Mysql,Postgres,SQlite and SQl) -Automation -Data warehousing on sql,mysql and postgres database (Star Schemas) and Business Intelligence systems development -Data extractions using Talend Open Studio,Python -Data Intergration using WSO2 ,Talend Open Studio -I have rich experienced in Database Administration, Excel -Data visualisation using Power BI,BIRT ,Jasper ,excel and Tableau -SQL server installations I am looking for the clear final requirements docs of your project so that I can start working immediately. If you need to discuss with me for any kind of suggestions or information, please knock me anytime. I am looking forward to hearing from you I can assure that if you work with me once, you will always work with me on these kind of projects and I can deliver quality and superior work at a price we are both comfortable with and within the agreed timeline. Kindly consider my bid.I will do whatever it takes to complete this project and earn a 5 star rating from you as well Kind Regards Takudzwa
€19 EUR in 7 days
4.9 (36 reviews)
4.8
4.8
User Avatar
Hey I have experience in writing SQL queries and created data ware houses by integrating different data sources. I can complete the query you posted in one day. Please initiate chat to discuss further.
€19 EUR in 1 day
5.0 (6 reviews)
4.8
4.8
User Avatar
Hi, this is definitely doable, would you mind sharing couple more examples and i will try to create the query for you immediately. I've done this many times before without a single problem and i am available right now. Thanks, Milan
€15 EUR in 1 day
5.0 (22 reviews)
4.3
4.3
User Avatar
I can do this task in less than 30 mins I have more than 12 years of experience in Oracle/ SQL/ MySQL/ PostGre Server database modelling, design, development, and Administration. I have worked for database designing and modelling of complex business an efficient way. I have very good experience in TSql, writing complex scripts, complex stored procedures, functions, triggers etc. I am good with performance tuning which includes Index and its usages, JOINS, dynamic queries, CTE, Temp tables, Table variable, and all its usages. I am also good and working with big clients for BI part like SSIS, SSRS and SSAS. Created different workflow PACKAGES and reports for clients. I also involved in Data warehouse design form OLTP systems. I have worked with medium to large mission critical databases. Worked as DBA for 24*7 support environment. Involved in activities like Performance monitoring, Log file maintenance, deadlocks and blocking handling, disk space management, Job monitoring and failure handling, Backup and recovery process for disaster management
€8 EUR in 1 day
4.9 (12 reviews)
3.1
3.1
User Avatar
Hey Herman V. I see what you got and I'm glad to share my expertise that I've completed multiple projects in SQL and Microsoft SQL Server Would love to show you my portfolio regarding SQL and Microsoft SQL Server,as I am capable of doing modifications and adding functionality to prebuild programs Let's jump on a chat or call for further discussion about the project. Cheers!! Nazish
€25 EUR in 4 days
5.0 (2 reviews)
2.6
2.6
User Avatar
Hi! I am skilled SQL coder with skills including Microsoft SQL Server and SQL. C#, ASP.net, ETL, BI, DBA, SQL and PL/SQL Expert 15+ years experience in software development, database programming and administration, and project management. Specialist: SQL, PL/SQL, T-SQL, PL/pgSQL, ETL, Database Migration, SQL Optimization, Stored Procedure , C# , ASP.NET, AWS, Google Cloud, Microsoft Azure Database Expertise: MySQL, MariaDB, Oracle, MSSQL Server, PostgreSQL, EnterpriseDB, DB2, MS Access Database Administration and Programming: Install, configure and administration database server Design and Implement real time database replication and clustering Design and Implement data warehouse solution Database load balancing Database backup and recovery Database performance tuning and optimization Database Migration SQL Optimization Creating procedure, functions, triggers and packages Web Application Development: ASP.net, C#, HTML, CSS, Java Script, Ajax, Jquery, Entity Framework, Crystal Report, Microsoft Reporting Desktop Application Development: VBA, VB6, VB.net, C#, Crystal Report, Microsoft Reporting Application Server and Middle-ware: IIS, Apache Tomcat, HaProxy, PgPool-II, Proxy SQL Cloud Computing: Google Cloud, AWS & Azure. Operating System: Red-hat Linux, Centos, Ubuntu, Windows DevOps and Automation: Ansible, Python, Bash Shell Script, Jenkins, Apache Airflow ERP and CRM: Microsoft Dynamic Great Plan (GP) Microsoft Dynamic CRM Customized ERP Please contact me to discuss more about this project. Thanks & regards
€139 EUR in 2 days
3.2 (1 review)
3.9
3.9
User Avatar
Query building in MSSQL - split result in different values Hello Herman V., Hope you are doing great. I went through your project description and it seems like I really am the perfect fit for your Task. I have 10+ years of experience on SQL, Microsoft SQL Server. You can check out my freelancer portfolio section. I will also share my portfolio on further demand over a chat. Please come over chat and discuss your requirements in a detailed way. Thanks. Best Regards, Muhammad Hashir CEO at KARIS Smart Solutions
€19 EUR in 7 days
4.8 (1 review)
1.2
1.2
User Avatar
Hi, I have more than 3 years in writing MySQL queries, creating scripts over Python, performing complex excel functions and schedulers. In Data Visualization I have created various dashboards, reports on Power BI and Snowflakes. Recently I have completed Web scraping project on Dynamic websites and Data Processing Project where I processed more than 100 images to system and extracted text from them using Python. I can promise to share the required query within an hour. Regards, Himanshu
€8 EUR in 1 day
5.0 (2 reviews)
0.3
0.3
User Avatar
Hello, I worked on similar query result before and i can split it for you in less than 15 minutes. I'm available to start it now. let you check my experiences and remaining at your disposal to discuss more and give you the solution if you want.
€10 EUR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi! Instead of wasting the time for my brief introduction, lets come to the point that I can solve your problem and can split your query results, as desired. Please contact, if you want the solution. Regards Muhammad Uzair
€25 EUR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi there, I will perfectly meet with your requirement . And i need more details and need to discuss in detail.
€19 EUR in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have more than 14 years of IT experience with various database technologies. Working Knowledge of Oralce,postgres Databases. Strong experience in Oracle to postgres migration Strong Oralce Development Skills working experience in Database design. Optimize Oralce prcedure & function Expertise in developing skill , proficient in T-SQL writing stored procedures, triggers and functions. Worked in build complex query. Database tuning experience. Good written and client interaction skills at all management level. Energetic self-starter and can learn new technology in short time. Tuning query performance and recommending better way to optimize SQL queries and pl-pgsql/T SQL programs Having Developing/DBA experience of postgres database size more than 10 TB
€19 EUR in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi I can write this query immediately after hiring. I'm experienced full stack developer, please inbox for more discussion, thanks. Best Regards Amir
€10 EUR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
8 year experience in sql Statement, bulid end to end system Good at query writing For more detail we can chat
€8 EUR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have 15 years experience working with sql query. I think i'm the best candidate for this task. Give me a try. Thanks before
€20 EUR in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of BELGIUM
Mechelen, Belgium
5.0
24
Payment method verified
Member since Mar 29, 2017

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.