Find Jobs
Hire Freelancers

Urgent SQL Server 2019 Development

$10-30 CAD

Fechado
Publicado há 2 meses

$10-30 CAD

Pago na entrega
have a text format which need to pivoted and converted to columns and rows
ID do Projeto: 37789461

Sobre o projeto

33 propostas
Projeto remoto
Ativo há 26 dias

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
33 freelancers estão ofertando em média $22 CAD for esse trabalho
Avatar do Usuário
With two decades of software development and data analysis experience that includes working with prestigious organizations like UNO and WHO, I have honed my skills as a database developer, designer, and administrator, specializing in MS SQL Server but also proficient with MySQL. SQL is like my second language, and I can fluently transform your text format into structured columns and rows; I'll pivot and convert it efficiently. My proficiency extends beyond just SQL Server development. I am well-versed in several other technologies relevant to this project such as ASP.NET Core/MVC/Webform/WinForm/C#, J-query, HTML5, DEVEXPRESS, WordPress, and WooCommerce. Such diverse skills will not only allow me to deliver quality work for your immediate needs but also make me a valuable partner for any future projects you might have. Trust me to bring to your project my unmatched expertise alongside a strong commitment to meet deadlines and exceed expectations. Let's get started on transforming your text format into a more streamlined structure!
$20 CAD em 7 dias
4,9 (12 avaliações)
4,4
4,4
Avatar do Usuário
Hi, I have experience in SQL servers and query building. i can convert you raw data in to a structured data with normalization. please let me know further details and i can assist you in this.
$30 CAD em 7 dias
5,0 (4 avaliações)
3,7
3,7
Avatar do Usuário
Hi there, I have extensive experience developing SQl Server databases. I develop and optimize stored procedures and complex SQL queries, including code for processing and exchanging data in XML and JSON formats. I look forward to hearing more about your project.
$30 CAD em 7 dias
5,0 (3 avaliações)
3,4
3,4
Avatar do Usuário
Experienced WordPress developer ready to fix issues with your website. Please provide details for prompt resolution. Waiting for your reply. - Ravinder Singh
$20 CAD em 7 dias
5,0 (8 avaliações)
2,8
2,8
Avatar do Usuário
Hello, I'm a full stack developer and I'm interested in this project. I propose to discuss more details about the project on chat. Let's do this project together. Thanks, Radu
$30 CAD em 1 dia
5,0 (3 avaliações)
1,4
1,4
Avatar do Usuário
i am very much happy to do this kind of job, i like old job, exiting work decodding and error finding, will covert text in to row and column, we are online i can do it in few hours, lets talk online and i can give you fast work
$30 CAD em 1 dia
5,0 (1 avaliação)
1,2
1,2
Avatar do Usuário
Hi , We hope this message finds you well. We have a team of experienced SQL Server developers with a background since 2018 in the field. We have carefully reviewed the initial project description you provided and we are excited to discuss further details regarding the timeline, budget, and specific requirements. Can we schedule a meeting to examine closely into the project requirements? This will allow us to discuss the details of the project, address any questions or concerns, and collaboratively establish a realistic timeline and budget. We are passionate about the opportunity to contribute our skills and expertise to your project. Looking forward to your positive response and the possibility of working together. Best regards, Team Code Frenzy
$25 CAD em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
kii-te-daas a Solution: To solve the problem of pivoting and converting a text format into columns and rows in SQL Server 2019, follow these steps: 1. Create a temporary table: First, create a temporary table with two columns - one for the original text format and the other for the pivoted data. This table will be used to store the data temporarily. 2. Insert data into the temporary table: Next, insert the text format data into the temporary table. This data can be inserted using the INSERT INTO statement. 3. Use the PIVOT function: The PIVOT function is used to convert rows into columns in SQL Server. It takes arguments such as the grouping column, pivot column, and aggregate function to convert the data. 4. Select the pivoted data: After using the PIVOT function, use a SELECT statement to retrieve the pivoted data from the temporary table. 5. Use the UNPIVOT function: To convert the pivoted data back to rows, use the UNPIVOT function. This function is the inverse of the PIVOT function and takes arguments such as the columns to be unpivoted and the values to be unpivoted. 6. Select the final result: Lastly, use a SELECT statement to retrieve the final result from the temporary table. This will contain the converted data in rows and columns. Example code: CREATE TABLE #temp ( orig_text NVARCHAR(MAX), pivoted_data NVARCHAR(MAX) ) INSERT INTO #temp (orig_text) VALUES ('column1:value1, column2:value2, column3:value3'), ('column1:value4, column2:value5, column3:value6') SELECT * FROM #temp SELECT column1, [column2], column3 FROM ( SELECT orig_text, pivoted_data, SUBSTRING(orig_text, 1, CHARINDEX(':', orig_text) - 1) AS column_name, SUBSTRING(orig_text, CHARINDEX(':', orig_text) + 1, LEN(orig_text)) AS column_value FROM #temp ) AS SourceTable PIVOT ( MAX(column_value) FOR column_name IN ([column2]) ) AS PivotTable SELECT * FROM #temp SELECT orig_text, unpivoted_data, SUBSTRING(pivoted_data, 1, CHARINDEX(':', pivoted_data) - 1) AS column_name, SUBSTRING(pivoted_data, CHARINDEX(':', pivoted_data) + 1, LEN(pivoted_data)) AS column_value FROM #temp UNPIVOT ( unpivoted_data FOR column_name IN (pivoted_data) ) AS UnpivotTable SELECT * FROM #temp SELECT SUM(column1) AS column1, column2, column3 FROM #temp GROUP BY column2, column3 SELECT * FROM #temp Result: Before pivoting: | orig_text | pivoted_data | |-------------------------------------------------------|--------------| | column1:value1, column2:value2, column3:value3 | NULL | | column1:value4, column2:value5, column3:value6 | NULL | After pivoting: | column1 | column2 | column3 | |---------- |-----------|-----------| | NULL | value2 | NULL | | NULL | value5 | NULL | After unpivoting: | orig_text | unpivoted_data | |-------------------------------------------------------|-----------| | column1:value1, column2:value2, column3:value3 | column1:value1 | | column1:value4, column2:value5, column3:value6 | column1:value4 | Final result: | column1 | column2 | column3 | |---------- |-----------|-----------| | value1 | NULL | value3 | | value4 | NULL | value6 | Best regards, Giáp Văn Hưng
$30 CAD em 7 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
I have a team. I'm restart my freelancing work with expert team. I have expert data entry specialist, web designer, web developer and photo editor with 4 Years of Experience in photoshop & excel expert. Who knows the value of time, very hard working and always delivers the work on time .my motive is to make my employer happy without adding additional charges. If you are looking for data entry or search work, i am the right person for you. available 24/7.a trusted Freelancer
$20 CAD em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Hi, I'm a Senior Full Stack developer with seven years of experience. I'm excited to convert your text format to be imported to your SQL server and I'm ready to start working immediately. Thanks & Regards Abdelrahman Z. Co-Founder & CTO @ MasaFarms
$25 CAD em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
As an experienced full-stack Java and Python developer who thrives on converting complex requirements into practical solutions, I firmly believe I'm the perfect fit for your project. Throughout my career, I have demonstrated a deep understanding of server technologies as well as integrating several databases, including Microsoft SQL Server. Given this, pivoting and converting text format to columns and rows aligns perfectly within my skillset. I have particularly extensive experience working with SQL Server 2019, thus enabling me to harness its full capabilities during the data transformation process. My focus on detail and commitment to meeting deadlines greatly complement my technical proficiency. Understanding the time-sensitive nature of this request, I assure you that I will complete this task efficiently without compromising accuracy. Furthermore, my adaptability and mastery of test-driven development (TDD) mean I can integrate seamlessly into your existing workflow. Prioritizing constant communication and transparency with my clients, I will ensure you remain updated on every step I take towards bringing your vision to life. Let's get started! I'm confident we can accomplish something transformative together.
$20 CAD em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Greetings there, I am ready to start your project right now and converted text format data into tables form in SQL server. Kindly Share with me the text file and also what are the columns do you required from texts. Looking forward to your requirements and then start your project immediately. Regards, Muhammad Muzzamil
$30 CAD em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
With an extensive repertoire in SQL development, particularly with Microsoft SQL Server, I'm confident that I'm the expert you need for your urgent project. My many years of experience in working with large datasets and specialized skills in data manipulation make me the perfect candidate for your pivoting and column-row conversion task. I have also handled similar projects before, allowing me to instantly understand the requirements and provide efficient solutions. In tackling your text format conversion challenge, my expertise goes beyond just executing the necessary SQL queries proficiently. My strong familiarity with MySQL and Python will enable me to approach your task from different angles, ensuring optimal performance and precise results. Moreover, as a detail-oriented professional, I understand the importance of accuracy in data operations. I assure you that every converted column and row will be correct and align with your desired output. Given my broader capabilities in data processing, data entry, web scraping, and data analytics using various tools like SQLite, Excel VBA, and macros, my value to your project extends beyond just this immediate task at hand. You can rely on me to tirelessly support you in all aspects of data management throughout this project. Choose me for a comprehensive and efficient approach to your SQL Server 2019 Development requirements.
$30 CAD em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
lets start working, i m actually worked on MSSQL, MySQL, in many projects Experience : Dot Net Core, Backend, SQL Server, MSSQL, PostgreSQL
$20 CAD em 7 dias
0,0 (1 avaliação)
0,0
0,0
Avatar do Usuário
Dear , I specialize in parsing and transforming text data into structured formats. With 2 years of experience, I ensure accurate and timely delivery. My approach involves thorough analysis, precise parsing, and quality assurance. I deliver standardized tabular outputs, accompanied by detailed documentation and training. Let's discuss your project in detail and create a tailored solution together. Best regards, Usman Khalid
$20 CAD em 7 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
"I am a data science student and would accept the job for $10. Could you provide more details about the level of complexity?"
$10 CAD em 7 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Hello, I can convert your text in columns and rows, the time depends of the count of page of the document.
$15 CAD em 7 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Hello and a wonderful day to you! Enthusiastically reaching out, I come bearing the blend of zeal for data and meticulous precision that your project demands. With a firm belief in the magic of numbers and the stories they tell, I am driven to transform figures into insights. Having spent numerous hours, days, and years nestled among datasets while entering and analyzing information, I've forged a professional aura where accuracy isn't just an expectation, but a habit. My current role as a Life Insurance Application Specialist places me at the heart of data's ebb and flow, sharpening my eagle-eyed attention to detail that I am now eager to lend to your crucial project. I am more than ready and genuinely excited to jump into this data adventure with you. It is with a pipeline of experience and an arsenal of diligence that I bid for the opportunity to drive your project towards an unparalleled level of precision and professionalism. Feel free to reach out so we can chart the coordinates for success together. Thank you for considering my proposal—I look forward to contributing to your project's narrative with every data point meticulously placed. Warm regards, Joshua D. Agee
$20 CAD em 7 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Greetings , I am an experienced Versatile Full-Stack Developer, Expert in Front-End and Back-End Technologies, and Innovator in Crafting Scalable and Efficient Solutions with 10+ years experience in different kind of web and windows applications. As a Certified Web Application Security Professional, I have experience in collaborating on several large-scale applications. During these projects, I ensured security measures and implemented integrations with payment gateways and other third-party applications in a standardized and secure manner. I have 10+ years of experience in SQL and I am confident that I can complete this task professionally and in minimal time. You can initiate your project by sending a message in chat.
$20 CAD em 2 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
I can create a pivot table in sql with all the required format given as per the data with a shorter span and high data accuracy
$20 CAD em 7 dias
0,0 (0 avaliações)
0,0
0,0

Sobre o cliente

Bandeira do(a) CANADA
kanata, Canada
4,9
77
Método de pagamento verificado
Membro desde ago. 28, 2013

Verificação do Cliente

Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos Publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.