Find Jobs
Hire Freelancers

Hire a sql developer to break out build of material list

$250-750 USD

Cancelled
Posted over 6 years ago

$250-750 USD

Paid on delivery
I have a ms sql query that breaks out my build of material list into parent assembly, assembly, and components. I want to break down this table into components. I want to go through the entire list and get how many components each assembly has and tie it up to the parent assembly. I want to do this dynamically. So when the with the original build of material changes I can run this new sql to get any new components that were added or taken away.
Project ID: 15361823

About the project

19 proposals
Remote project
Active 7 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 $436 USD for this job
User Avatar
Hello Sir, This looks like a BOM (Bill of Materials) query and if this is the case, I have worked on this in past (Discrete ERP). May I please request to open the chat and discuss this. Thanks Aanvik Relevant Skills and Experience MSSQL, ERP Proposed Milestones $588 USD - Default Milestone
$588 USD in 10 days
5.0 (34 reviews)
6.4
6.4
User Avatar
Hi depending the needs i will use a SP or Function , in order to do this i will need a copy of your DB or a connection via RDP, Relevant Skills and Experience MSSQL Proposed Milestones $300 USD - at the begin How big is your DB
$300 USD in 5 days
5.0 (40 reviews)
5.8
5.8
User Avatar
I am a MCSA SQL Server 2014 certified professional, with more than 10 years of experience in SQL related projects and tasks. Currently I work with T-SQL on a daily basis. Relevant Skills and Experience T-SQL: Advanced English: Near-native Proposed Milestones $450 USD - Job done.
$450 USD in 3 days
4.9 (17 reviews)
5.5
5.5
User Avatar
Hello sir/madam I work with SQL Server over 10 years and I am ready to help you with your project. Please just share your database schema with some fake data and I can start working on your project. Relevant Skills and Experience Almost 10 years of experience as MS SQL Server developer. Ready to work remotely if you prefer it Proposed Milestones $350 USD - After job is done and you are satisfied with results
$350 USD in 3 days
4.9 (12 reviews)
5.3
5.3
User Avatar
I'm a native English speaker based in UK and able to work evenings to fix US office hours. I'd write a set of stored procs / views to carry out this work and back these up with tSQLt tests. Relevant Skills and Experience I have 8 years experience of T-SQL as database developer / DBA including experience of writing stored procedures to give different views of bundles and bills of materials in real time. Proposed Milestones $130 USD - Write and test views to explode bill of materials $147 USD - Write and test tables and stored procedures to manage change What version of SQL server do you use please? How many records involved?
$277 USD in 5 days
5.0 (3 reviews)
4.5
4.5
User Avatar
I am new to freelancer.com but have been freelancing off and on for the past 20 years. Relevant Skills and Experience I've been writing SQL Queries since v7 was the latest and greatest (pre-SQL 2000). And I've utilized with ASP to build extensive backend systems including customer, inventory and employee management. Proposed Milestones $100 USD - Create a cental stored proc to handle the business logic and will call additional stored procs $100 USD - Create temp table to handle the parsed assembly data for duration of the task $200 USD - Create a stored proc using cursors to walk through the assemby data and add to the temp table $200 USD - Create a stored proc to query the results and pull your aggregate data. Additional Services Offered $100 USD - Debugging and optimizing existing queries. How do you want the resultant data delivered?
$600 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have experience in building queries in a variety of languages, including SQL. I also have a background in Supply Chain and Manufacturing, so I understand product families and BOMs. Relevant Skills and Experience SQL, data science, supply chain, manufacturing Proposed Milestones $20 USD - Align on Project Scope and Deliverables $100 USD - Proof of concept (sample data) for review and refinement $602 USD - Deliver project results
$722 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Build database to specifications as directed. Relevant Skills and Experience Daily work is in design, development, deployment, and maintenance of SQL Server databases. Proposed Milestones $444 USD - Develop database with required scripts
$444 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I can build a dynamic query which gives list of components at any point of time. Have very good sql skills with quick turnaround Relevant Skills and Experience oracle sql for 9 years Proposed Milestones $555 USD - query is this oracle database?
$555 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have Over Fifteen years of expertise in design and, development in relational database. I have experience in Oracle, MS SQL Server, Data Modelling, Data migration, Power BI, Visual Basic. Relevant Skills and Experience Oracle, MS SQL Server, Data Modelling, Data migration, Power BI, Visual Basic Proposed Milestones $300 USD - Design $311 USD - Final
$611 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I'd like participate the project. I have enough time and experience to do this. Relevant Skills and Experience I'm have good 12 years experience with database development and administration (was a team member of MS SQL Srvr 2005, now mostly work with MS SQL Srvs 2014 and Postgres). Proposed Milestones $400 USD - Query is done and internally tested $99 USD - Minor fixes if needed, tuning the performance, access and so on. Finally done at the step. $1 USD - Finally done at the step. Could you please share the db structure with me? I need this info to make proper queries.
$277 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$277 USD in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am an programmer with skills in C# and MSSQL. 3+ years experience.
$333 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Analisis de Proyecto para poder mejorar la estructura elaboracin de Diagramas Habilidades y experiencia relevante amplia experiencia en desarrollo con SQL server Htos propuestos $555 USD - analisis y desarrollo tienes Diagramas elaborados en tu base de datos
$555 USD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
lexington, United States
5.0
1
Payment method verified
Member since Oct 9, 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.