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] (
SELECT distinct event_time
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')
32 freelanceri licitează în medie 91$ pentru acest proiect
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
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
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
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
I will charge 100 USD for this project. Let me know if you can afford it Looking forward to your response. Thanks George.
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
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
***** 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
I can provide you solution within next couple of hours. Let me know if you need to get the fix today.
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.
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!
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.
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
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
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
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
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
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