tsql test script

$10-30 USD

已完成

已发布

超过 5 年前

$10-30 USD

货到付款

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

项目 ID: 17526106

关于此项目

18提案

远程项目

活跃6 年前

想赚点钱吗？

电子邮箱地址

在Freelancer上竞价的好处

设定您的预算和时间范围

为您的工作获得报酬

简要概述您的提案

免费注册和竞标工作

颁发给：

@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 在1天之内

5.0

(2条评论)

1.6

18威客以平均价$24 USD来参与此工作竞价

@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 在1天之内

5.0

(187条评论)

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 在0天之内

4.9

(62条评论)

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 在1天之内

4.9

(13条评论)

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 在1天之内

4.6

(9条评论)

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 在1天之内

0.0

(0条评论)

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 NEED. PLEASE SHARE FURTHER INFORMATION. THANKS

$25 USD 在1天之内

0.0

(0条评论)

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 在3天之内

0.0

(0条评论)

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 在1天之内

0.0

(0条评论)

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 project with my work experience and knowledge. Regards, Shweta

$30 USD 在1天之内

0.0

(0条评论)

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 在1天之内

0.0

(0条评论)

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 在2天之内

0.0

(0条评论)

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 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.

$25 USD 在1天之内