Find Jobs
Hire Freelancers

SQL Query creation

£20-250 GBP

Completed
Posted about 4 years ago

£20-250 GBP

Paid on delivery
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 .
Project ID: 24378918

About the project

71 proposals
Remote project
Active 4 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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
£20 GBP in 1 day
4.9 (73 reviews)
5.7
5.7
71 freelancers are bidding on average £142 GBP for this job
User Avatar
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
£150 GBP in 3 days
5.0 (390 reviews)
8.2
8.2
User Avatar
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
£50 GBP in 2 days
5.0 (153 reviews)
8.0
8.0
User Avatar
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
£150 GBP in 3 days
5.0 (62 reviews)
6.4
6.4
User Avatar
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
£230 GBP in 7 days
4.9 (7 reviews)
6.2
6.2
User Avatar
----- 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 ....
£240 GBP in 7 days
5.0 (56 reviews)
6.2
6.2
User Avatar
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
£35 GBP in 3 days
5.0 (86 reviews)
6.0
6.0
User Avatar
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
£200 GBP in 7 days
4.9 (38 reviews)
5.9
5.9
User Avatar
Most of my projects in this site are sql database related which I have completed with glowing reviews ,if awarded I can deliver on time
£140 GBP in 7 days
4.9 (49 reviews)
5.6
5.6
User Avatar
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
£222 GBP in 2 days
5.0 (52 reviews)
5.2
5.2
User Avatar
Hi, My name is Ali and I can work on it with immediate availability. Let's have quick discussion so I can work on it.
£135 GBP in 7 days
5.0 (47 reviews)
5.3
5.3
User Avatar
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;
£300 GBP in 7 days
5.0 (33 reviews)
5.0
5.0
User Avatar
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).
£33 GBP in 2 days
5.0 (37 reviews)
4.8
4.8
User Avatar
Hello. I can help you. I have more than 10 years of experience in database administration and querying over SQL Server technologies. Thanks, regards.
£50 GBP in 1 day
5.0 (13 reviews)
4.9
4.9
User Avatar
hi , i am working on .net application with sql server from last 6 year , i am looking forward for your project thanks regards tscreators
£250 GBP in 7 days
4.9 (22 reviews)
4.9
4.9
User Avatar
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.
£200 GBP in 2 days
5.0 (2 reviews)
4.4
4.4
User Avatar
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.
£199 GBP in 7 days
5.0 (4 reviews)
4.5
4.5
User Avatar
I am good in SQL powerhsell along automation and development, please let me know if you are good to award this project to me
£150 GBP in 7 days
5.0 (8 reviews)
4.6
4.6
User Avatar
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
£100 GBP in 2 days
5.0 (9 reviews)
4.3
4.3
User Avatar
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
£277 GBP in 1 day
5.0 (4 reviews)
4.4
4.4
User Avatar
Hello. Iam expertise in sl server and stored procs with excellent querying if u are interested ping me i will make ur automation simple
£188 GBP in 2 days
4.9 (21 reviews)
4.5
4.5

About the client

Flag of UNITED KINGDOM
Newton Abbot, United Kingdom
4.8
13
Payment method verified
Member since Jun 22, 2016

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.