I need a tsql script to generate some test data
1. for each row in a table, read the companyid and customer name
2. for each company generate a 7 column transaction for each first of the month between the start date and the end date (current month)
3. test if transaction exists in a second table and if not, insert it
a transaction would look like
[CompanyID] read name from first table
,[TransID] NULL
,[TransType] 'Maintenance'
,[InvoiceNumber] NULL
,[Customer] read name from first table
,[SettlementDate] 1/1/2017 ( and every first of the month until current month
,[Amount] 99
Hi,
This is easy and i can do it in few minutes.
Its just getting the data from parent table and then looping for the months and then insert data in new table.
Thanks,
Rohit
$20 USD in 1 day
5.0 (2 reviews)
1.6
1.6
18 freelancers are bidding on average $24 USD for this job
Hi, I would like to write tsql to generate the transaction and check in the table if it exists.
Get in touch to discuss more.
Available to start now.
Regards,
Manish
Hi,
I am Pragya from Tech Blue Ink sales department and will be coordinating with you regarding the Technical & Development aspects of the project. Please chat to discuss more on this or drop a mail.
Thanks
HI, I AM A PHP PROGRAMMER AND WEB DEVELOPER. I HAVE A LOT OF EXPERIENCE IN PHP CODING
AND DIFFERENT KINDS OF SCRIPTING LANGUAGES. I HAVE DEVELOPED MANY DYNAMIC WEBSITES USING PHP AND SQL.
I CAN MAKE SURE WHAT YOU NEED. PLEASE SHARE FURTHER INFORMATION.
THANKS
Hi,
Hope you are doing well!!
I would like to submit a proposal for "SQL Developer". I have around 8 yrs of experience in writing SQL queries to generate the reports and testing the data. I can help you with this project with my work experience and knowledge.
Regards,
Shweta
Hello,
I have worked a lots of SL projects.
i have 5+ years of experience in development. you can give me this project.
I am assuring you, i will complete this project.
I have tweenty years experience of SQL of Oracle. I can do it in one day but It says two days because there may be some situation that does not allow me to meet the deadline
I'm an experienced freelancer database and report design, development and optimization with more than 9 years of experience . I have used Erwin tool for data modelling and i am well-versed with Normalization's for doing DB design.
Here is few technologies I have mastered since last 9 years and can deliver the best solutions if you get me hired.
1) Sql Server 2005/2008/2012
2) MYSQL, MS Access
3) Oracle (PL/SQL),
4) SSIS, SSRS , SSAS and Power BI
5) Data analytics using R-Programming and SAS.