Închis

Modify Script

I am running the following query and it is running fine. This query loads data into AuditInfo table from previous day. Now if I run this query three times it will load data three times in the table.

The way I want to run the query, is to delete previous day data if any first from Auditinfo table then load the data. In other words, if I run the query 2 times, so when I run the query 2nd time

it will delete the records which was inserted first time for previous day and then insert the data. In other words for several run of this query for the day it will not insert the same records. Please let me know how much you will charge.

---------------------------------------------------------------

INSERT INTO Test.[dbo].[AuditInfo] (

event_time

,action_id

,server_principal_name

,server_instance_name

,database_name

,schema_name

,object_name

,statement

)

SELECT distinct event_time

,action_id

,server_principal_name

,server_instance_name

,database_name

,schema_name

,object_name

,statement

from sys.fn_get_audit_file('O:\Audit\Data1\*.*', DEFAULT, DEFAULT)

WHERE (SELECT CONVERT(VARCHAR(10), event_time, 111) as aa) = ( SELECT CONVERT(VARCHAR(10), (SELECT dateadd(day,datediff(day,1,GETDATE()),0)), 111) as bb)

and server_principal_name not in ('DEANFOODS\svc_tdsql') and action_id in ('IN', 'DL', 'UP')

Aptitudini: SQL, MySQL, Server Microsoft SQL, PHP, Arhitectură software

Vezi mai multe: please let know will start project, translate let know game went spanish, please let know translation program urdu english, shell script to edit a file using vi, how to edit script in linux, powershell script example, powershell script tutorial, edit shell script in terminal, filemaker scripts, how to edit shell script in linux, edit script software, please let know question translate french, grammar please let know send samples, php joomla let know can handle, site modify script, translate spanish english please let know questions concerns, can provide information background qualifications please let know, shoutcast modify script, please let know status invoices, php product delete modify script

Despre angajator:
( 4 recenzii ) FRISCO, United States

ID Proiect: #23910980

32 freelanceri licitează în medie 91$ pentru acest proiect

gopalvora

Hi i can Modify Script i am expert at PHP , SQL , Software Architecture , MySQL , Microsoft SQL Server So send me Private message at PMB so we can discuss more about it Thanks

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 7 zile
(533 recenzii)
8.4
sumon355

Hello, I can create a stored procedure for this which will delete the previous day data and insert the new data. Looking forward to have a positive response from you. Thanks

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(343 recenzii)
7.8
siddhu1986

Hi, I am an experienced Web Professional with years of experience in MySQL/PHP. I can update your script so that your query does not duplicate existing data. I can do this for you in a matter of hours. I can start now Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(456 recenzii)
7.4
siteshopping

Hello. I can complete this task within $140 and 2days I have extensive experience with Microsoft SQL Server, MySQL, PHP, Software Architecture, SQL. I am a full stack developer with 8 years of experience building web a Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 7 zile
(13 recenzii)
6.0
george1205

I will charge 100 USD for this project. Let me know if you can afford it Looking forward to your response. Thanks George.

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(11 recenzii)
5.7
RushService

Feel fee to contact me for Modify Script .Shoot me message to discuss further more details .We provide the comments,images,videos,demos and live sessions in order to help the [login to view URL] payment only after the wo Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(60 recenzii)
6.0
Panda393

Hello. I have read your project description carefully. I am a web specialist and I have full experience in php, mysql. I will do my best for you. I am a honest freelancer and I think actions speak louder than words. I Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(20 recenzii)
5.6
kirilnberezebko

***** Database Management Expert ***** I have read your job description carefully. I have full experience in Mysql, Sqlite, MongoDb, Nosql, and Firebase. So I can do your project perfectly. If you give me a chance, I w Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(16 recenzii)
5.5
ForeignTree

I can provide you solution within next couple of hours. Let me know if you need to get the fix today.

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(24 recenzii)
5.5
BelisaG

Hi dear. I am very interested in your project. As for me, I have strong skill in SQL of Mysql and MSSQL. Please contact me and let's start right now Thank you. Regards.

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(5 recenzii)
4.5
markomilovanovi9

Dear client, how are you? I am Marko. I have deep experience in SQL. I can start your project now and will give perfect results. Please message me in order to discuss about more details, thanks!

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(17 recenzii)
4.6
nemanjadj20

Hi, there? I have worked on similar projects to what you are looking for, and I am confident I can exceed your expectations. I can achieve the results that you are asking for. Thank you for your time.

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(7 recenzii)
4.4
fazalkareem95

Hello there I just came across your job request and noticed that what you are looking for is something I specialize in. I am good in squarespace , php javascript , along with other all languages. I have a good feelin Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 7 zile
(19 recenzii)
4.3
nproducts

Hi there, I can do this job please share with me cpanel details and sql table informations. I can do this $30 and deliver you within 1 business day. Waiting for your response :) Regards, Navneet

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(6 recenzii)
4.4
vimalsurani

Hello Sir, I have 5 + years’ experience of web site development. Expert in PHP, OpenCart, Magento, Wordpress, Drupal, Joomla, CodeIgniter and more. I am confident to handle your projects with dedication and good qualit Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(9 recenzii)
3.9
topdeveloper000

Hello Nice to meet you. I have read your all descriptions carefully and had a great interest on your project. Just now i am feeling confident to deliver the perfect reuslt on time with you budget. As a full stack de Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 7 zile
(4 recenzii)
3.9
AramBadalyan

Hi, Jamil N. I read your project detail carefully and have many interests in yourModify Script project. Having more than 5+ years of experience in Website development with PHP, MySQL, Javascript, i can fix your sql a Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 7 zile
(5 recenzii)
4.0
harihut

Hello Sir , Check my profile I am Core SQL Server DBA with 10+years of experience . I am expert in writing queries and stored procedure . I can help you to write this query for you . I guarantee you will have top notc Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(11 recenzii)
4.0
MiniDeveloper21

Hi There ! Hope you are feeling well. I am doing Software Engineering ,Having 2 years experience especially in programming (i.e. Java,C#,C++,C,Python),Code Debugging, Database connections, App development and much mo Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(9 recenzii)
3.7
SqlDevelopment

I have deep and proven experience in T-SQL development and debugging of queries with huge complexity. My total MSSQL Experience is 10+ years. Five of them was within USA company as Senior SQL/BI Developer. My everyday Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(14 recenzii)
3.5