tsql test script

Completed Posted 5 years ago Paid on delivery
Completed Paid on delivery

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

SQL

Project ID: #17526106

About the project

18 proposals Remote project Active 5 years ago

Awarded to:

dev54369

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
(2 Reviews)
1.6

18 freelancers are bidding on average $24 for this job

sumon355

Hello, As an expert in SQL, i am very much interested to write the sql script, but i am not fully clear. Let's discuss. Thanks

$26 USD in 1 day
(187 Reviews)
7.3
softcarve

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

$20 USD in 0 days
(62 Reviews)
5.4
sreenivas2903

hi I am expertise in sql server and tsql , could you please let me know the issue i will work and finish it

$34 USD in 1 day
(13 Reviews)
4.3
sachinraghav

Hello There, I have been working with SQL since last 4+ years. I would like to do your project. Message me for more details.

$15 USD in 1 day
(9 Reviews)
3.6
SalesTech2018

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

$30 USD in 1 day
(0 Reviews)
0.0
Intranetman

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 N More

$25 USD in 1 day
(0 Reviews)
0.0
SoftDevolmentKZ

Very simple task, just for $ 30. But in details I will delve into only if I choose myself as the executor of the project.

$30 USD in 3 days
(0 Reviews)
0.0
anton515

Hi, I can do it in a day as I am a high skilled sql developer. Please hire me, then I can start right now. Regards,

$30 USD in 1 day
(0 Reviews)
0.0
agrawalmani

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 More

$30 USD in 1 day
(0 Reviews)
0.0
ssameer702

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.

$15 USD in 1 day
(0 Reviews)
0.0
nubelo_ZiQIx7fa

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

$15 USD in 2 days
(0 Reviews)
0.0
sunilmudunuri

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 doin More

$25 USD in 1 day
(0 Reviews)
0.0