I need sql statement to update a table using pivot tables. The pivot table show monthly sales data ( 1-12 month) and I need to insert or update these data into another master table
Hi , if i have understood well, I will write an sql statement which will return a pivot table based on which you will make the update. It is crucial that the columns are always 12 (months).
Relevant Skills and Experience
MSSQL
Proposed Milestones
$50 USD - at the begin
Hi,
i would like to insert/update the pivoted sales data into the master table.
Relevant Skills and Experience
sql
Proposed Milestones
$15 USD - after completion
Hey
A SQL expert developer is here
I have good advanced expertise in Database development and writing SQL queries
I can write the SQL queries for you
Feel Free to message me
Regards
Hi, i have extensive experience in SQL queries. I'll be able to help you if you let me know details of your requirement.
Relevant Skills and Experience
SQL, MS SQL
Proposed Milestones
$10 USD - Provide update statemet
let me help you sir in pivot table as I have long experience in sql server , have full time and can start with you immediately , message me now and let's start work ;)
Relevant Skills and Experience
sql server
Proposed Milestones
$50 USD - pivot table
I am working on query from 4 year
Relevant Skills and Experience
MSSQL
Proposed Milestones
$14 USD - i can work with you according to your convinence
i need more detail
I can write the update query for dymannically and it can be use for need table using this singke query....
Relevant Skills and Experience
Currently i am working configurable projects and its column names are dynamic based on the fields configured in the page.
i can help you with this :D
Relevant Skills and Experience
i have excellent skill in sql
Proposed Milestones
$14 USD - i help the dvd rental shop create their huge database
I am a Software Developer with a Bachelor of Computer Science and Ten years experience in VB.net and MS Office
I have a thorough great knowledge of the MS Excel
Stay tuned, I'm still working on this proposal.
I did similar work of pulling data from excel in any format into tables,and it is a part of my regular job.
Relevant Skills and Experience
I Have SQL server knowledge as well as excel and know how to integrate these systems to exchange data in either ways.
Proposed Milestones
$15 USD - Will connect the excel to database and flush the data into a table
Additional Services Offered
$20 USD - Can share you the visualizations if required