I need you to develop some software for me. I would like this software to be developed for Mac using SQL. Using sqlpro, need a script to transpose columns into rows.
Current table structure:
Part, Loc, W1, W2, W3
PartA, Atlanta, 10,20,10
PartB, Dallas, 5,10,20
Desired table structure:
Part, Loc, Week, Qty
PartA, Atlanta, W1, 10
PartA, Atlanta, W2, 20
PartA, Atlanta, W3, 10
PartB, Dallas, W1, 5
PartB, Dallas, W2, 10
PartB, Dallas, W3, 20
Number of parts, location, weeks will change so can’t be hard coded
Thanks.
Hey !
I'm SAYAN PROGRAMMER
I've reviewed your complete job description.
I have more than 15 years of experience in this field.
if you will respond me then I will be able to explain my skills.
Relevant Skills and Experience
Mac OS, Software Architecture, Testing / QA, C programming , PHP and much more.
Proposed Milestones
$100 USD - initial milestone
Hi,
I have 4+ years of experience in SQL. I believe that this requirement can be achieved in the given time. I can also provide you a warranty support.
Please let me know if we can proceed further.
Relevant Skills and Experience
I have worked with Cognizant for the past 4+ years.
I have been into different DWH projects with various requirements.