Need automated Microsoft SQL Server query created.
Single database with 1 table.
table has 9 fields (see attached CBL image)
fields/columns will be populated with data from a device (see attached data text file)
query needs to be automatically run at 1pm and 5pm every day (I need to know how to change this if required)
query needs to parse the database for that specific day(based on the date stamp) and on the time period(based on the date stamp) eg when run at 1pm it must look for data entered into the database on that day from 6am till 1pm, and at the 5pm run look for data entered from 1pm till 5pm.
the query will count 9 rows of the same PRODUCT TYPE eg fish and output that data to a text file in a folder in comma seperated format(as per attached export text files) - I need to know how to change the location of the folder.
The text file must show the weight as the COMBINED REAL WEIGHT of the 9 products.
Any product type that is less than 9 at the 1pm run does not need to be exported to the text file, but at the
5pm run products that have 9 must be exported and any remaining must then be exported as a batch eg. if there is 15 rows of fish, then the first 9 get exported to 1 file, and the remaining 6 to another.
At each run of the script the text files must be overwritten with the new information (this information will then
be printed by a labelling program that parses the folder and the text files .
Dear Sir,
I can deliver SSIS package for you. We have setup data tools on your environment. since you have SQL server, datatools installations not take time and its comes nas feature for SQL server. if you could assign this task to me I can do the installation if necessary and create SSIS project as required and deploy on your MSDB catelog schedule it using SQL server agent job. you can change the time frequency acording to your requirement and also I can embed parameters to change the exported file location as required. to complete all the task will take maximum 2 hours time. please let me know your availability and the sql server version to send the recommendations.
I am a Tech-lead on Business Intelligence with more than 14 years of experience on MS SQL Server (SSIS SSAS SSRS) , Power BI. and also during last 14 years I involved many project in ETL, data warehousing. I would highly appreciate if you assign this job to me and also I'm Microsoft Certified Technology Specialist (MCTS) for Microsoft SQL Server for Business Intelligence Development and Maintenance & Microsoft Office SharePoint Server Application Development.
Best Regards,
Jinesh
Hello,
As an expert in SQL, i am very much interested to create the required query. If you want i can also develop an application for the same purpose. Let's discuss more.
Thanks
Hi there, I have read your initial requirements in details and I have some questions regarding to your sql query project. please send me a message so that we could discuss it further requirements , budget and timeline. We have 6 years plus experience in mobile , web, desktop application development and designing.
Regards
M ahsan
Hi there, I think we need to write a small program, read the in as the times you want to rub and pick the database you choose, we will count for the time range and export to text file. I can’t see att
Relevant Skills and Experience
10 years database programming
I understand what you are looking for. Because I’ve completed the done work before so I am sure it will not be a problem for me. I am highly professional and skilled web designer and developer (responsive) with more than 5 year experience of development. I am fully skilled and up to date with all web technologies/languages including (HTML5, AJAX, CSS3, Node.js ASP.Net, Wordpress, Drupal, Magento, PHP, Java, Python, Ruby, JavaScript, jQuery, Bootstrap, MySQL, Oracle etc.). I’ve read your project and understood. I assure you 100 % professional and user friendly work environment. Feel free to ask any question. Thanks
----- Query Autorun Scheduler Tool---------- I can develop you exactly you described the requirements ------------- I have read through your attachment and description, nothing found any difficulty for me , i will take less time to deliver .......... 20 years working with most popular databases with complex query creation and i have also Own Developed Autorun scheduler for different company to send PDF email based on Data Query ....
Hi
I have read the description of your project. I can propose several strategies to you to develop your project.
I would like to chat with you.
Experience to apply:
Microsoft platform:
Language: VB.NET / C #
ASP.net / Web form - / MVC
MySql Server / SQL Server
About
I am a web developer focused on Microsoft technologies,
I worked about 4 years developing web applications created with Asp.net and SQL Server 2005, 2008 and 2012
Hi There,
We need to create a windows program which we will schedule to run in task scheduler (will provide documenation on how to configure).
Location of the folder would be configurable and can be updated by anyone.
I believe in building long relationships, trust and good communication. I usually reply within minutes of ping from you. I'll wait for your ping on chat to discuss more on the project.
I have more than 10 years of experience in developing .NET solutions with building small and big distributed high-load applications. I am a technologist at heart with the right intent and skillset to deliver high-quality and stable projects in web application and hybrid mobile application using new technologies.
Regards,
Shobhit Pundir
Senior SQL Developer with 10+ years experience, worked during this time with several automation systems, Business Intelligence tools. Five years working within scrum team in USA product company. Also during my professional activity i gathered expertise and experience in several areas of IT from configuration development environment to delivery of developed product.
Areas of specialization:
● MS SQL Server DB Engine
● T-SQL
● MS Reporting Services ● DWH
● MS Integration Services ● ETL Processes
● MS Analysis Services
Proposal - I have gone through your project details and I will be able to implement using SSIS ETL tool. Let me know if you want to discuss further.
I am a database / Business Intelligence / solution architect. I have more than 14 years of experience in various technologies as mentioned below:
Database/Datawarehouse - SQL Server, Oracle, MySQL -- Proficiency (P4)
BI - Microsoft MSBI and Informatica ETL -- Proficiency (P4)
Dotnet - C# (core), ASP.Net (core), MVC, Javascripting etc... -- Proficiency (P3)
Cloud - Azure (Paas and IaaS) -- -- Proficiency (P1)
My Technical background
• A goal-oriented professional with more than 14 years of experience in IT Database Management and Project Management specifically Airlines, Telecommunications and Health care domain
• Having good amount of practical exposure on AngularJS, MVC, Javascript, ASP.Net with C#, VB.Net language and executed multiple projects independently.
• Possess expertise in Data Warehouse/Data mart concepts, data modeling for OLAP & OLTP systems from design and analysis to implementation including the conceptual, logical and physical data models
• Experience in relational and dimensional data modeling using ERWIN, understanding of Ralph Kimball and bill Inmon methodology for dimensional modeling, star and snowflake schemas
• Having depth knowledge of large database design techniques; experience in data analysis, data cleansing, and data transformation and migration using ETL tools;
I have a experience in asp.net, MVC, web API, c#, SQL, entity framework,linq, razor view (Cshtl), html, bootstrap,Angular JS, Jquery, Json,XML, reports (PDF,xls, crystal, rdlc,ssrs).
Hi,
My name is Milos specialized in Web Dev.
I can easily complete this task and exceed your expectations.
I am very familiar with .NET/SQL/DB admin/Query and have rich experience with them.
Based on your feedback, I can draft my proposal accurately and from there I can get started.
We can discuss more detail via chat.
Thanks.
Hi
I am a senior software engineer. I will develop this scheduler application for you.
I can develop it in either CSharp or Java.
I will make the full application configurable through a properties file. You will easily change the folder location and run time.
Looking forward to your reply.
Hi,
I’m a senior DBA (and developer), just started using the Freelancer.
I have a lot experiences with Databases (4y+), primarily with MSSQL.
For my current company, I’m responsible for multiple on premises hosted production servers. I also have database design skills , troubleshooting and performance tuning.
As a developer, I’ve build over 25 various systems (Web&Desktop) mostly in .NET.
Regarding your project, I’d create a simple solution using the stored procedures in the SQL and simple application in the .NET. I can handle both tasks as the topic of the job you’re proposing matches my daily work.
Scheduling can be achieved simply using Windows Task scheduler.
Let me know please, case you’re interested. I can start this evening.
Regards,
Frantisek Frys
Greetings,
I'm professional database and BI expert with 12+ years experience. Currently I'm working as Senior DW, BI & DB developer in one of the leader financial corporation. As you can see in my profile page, I have a deep experience of database related projects. I'm top expert.
--
Best regards,
Davit Dartsimelia
Senior BI & SQL Developer