Sql server 2005 remove row datecông việc

I'm currently battling with server configuration problems on my Microsoft Exchange 2016 setup. I'm in desperate need of a swift and permanent fix. - You will focus on troubleshooting and fixing the configuration issues that are affecting the overall performance of the Exchange Server. - You should be highly knowledgeable of Microsoft Exchange Server 2016 and should have had experience tackling similar issues in the past. Ideal skills and experience: - Expert knowledge of Microsoft Exchange Server 2016 - Proven track record troubleshooting and fixing server configuration issues - Excellent problem-solving skills - Fast and efficient communication This task is critical and demands immediate attention. Your expertise is needed to restore op...

...for detail, a passion for user-centered design, and a strong understanding of UI/UX principles. Key Responsibilities: Create wireframes, prototypes, and mockups to effectively communicate design ideas and concepts. Conduct user research and usability testing to gather feedback and iterate on designs. Ensure consistency and adherence to brand guidelines across all digital touchpoints. Stay up-to-date with industry trends and best practices in UI/UX design. Requirements: Proven experience as a UI/UX Graphic Designer or similar role. Proficiency in design tools such as Adobe XD, Sketch, Figma, or similar. Strong portfolio showcasing your design skills and projects. Excellent communication and collaboration skills. Ability to work in a fast-paced environment and meet deadlines. If...

...developer adept in API integrations, specifically taking messages from waziper via webhook and posting entered data within a Google Sheet. Task requirements include: - Integration of waziper webhook into an application - Extraction of 'Text content' and 'Sender's phone number' from the received message - Successful post of the extracted data to a Google Sheet, with each message creating a new row Ideal candidates would have experience in API integration, webhook setup, and Google Sheets manipulation. Bit of coding background might prove beneficial. I look forward for competent freelancers who can handle this task seamlessly. Format of API below: ://webhook.site/1b25464d6833784f96eef4xxxxxxxxxx&enable=true&instance_id=609AC

I'm in need of a Javascript developer who can bring my website up to date with some crucial changes. Here's what we're looking for: Content Updates: • Our site demands multiple image updates. We have a mix of actions - replacing existing images, adding new ones, as well as, resizing some. • Our maps are currently not functioning. These need an upgrade urgently so they can show the correct information again. • The contact form needs an update as well, which includes a phone version video addition. Functionality Enhancements: • As a part of functionality enhancement, focus should be drawn towards debugging and developing our site's javascript to support the mentioned changes. You should have a strong know-how of Javascript and experience work...

...without a front-end sales component. Our immediate needs include: Import/Export Module Update: Our module is outdated by four years, preventing Magento upgrades. We need to select and implement a new import/export solution from recommended options like Amasty, MageBees, Firebear Studio, or other suitable Adobe Commerce Marketplace products. Magento Upgrade: The platform is significantly out-of-date. An upgrade to the latest version is necessary for improved security, functionality, and compatibility with new plugins. Website Redesign: Aesthetic improvements are required to enhance the website's appearance and user experience. This includes layout, theme, navigation, and functionality enhancements. Payment System Implementation: We plan to add a payment processing system ...

I have a google sheet where we put 3 paragraphs of data into 1 cell. I have included an image showing the "reasoning" columns (D-J) which needs to be split into 3 sets of data (K-Q), (R-X) & (Y-AE) I already did the first row manually. For this job you need to split the cells into the target rows and also have a QA step and recombines the split data into a "QA Check" concatenation. Then a final check to verify that the original = QA check. This is to verify no data was lost. Here is a read only link to the sheet: https://docs.google.com/spreadsheets/d/1TiyKKNjrEHeCrNySmmiD9xWQXTjd1OAh-8fUluSLRR0/edit#gid=420694380 rows 4-509 need to be done. Only work with the new fields, do not edit the original data This needs to be done with formulas, not manua...

I am seeking a energetic data miner for detailed data harvesting regarding a list of provided football clubs across the globe. The ideal candidate should also be a proficient data entry expert informed ...and email), and social media profiles (Facebook and Instagram) as well as their official website. - Experience in dealing with sports data, particularly football-related, is a plus. - Input gathered data into a spreadsheet in a coherent, organized manner. - Must ensure accuracy and integrity of data. - Proficiency in Excel spreadsheet management is a must. - The provided information must be up to date. Note: The list of specified clubs will be provided upon project commencement. Apply and let me know your offer for 1000 clubs and timeframe! You may be asked to do 10-20 clubs as...

I’m in need of an expert who can extract and present detailed reports from Stripe Sigma SQL. Expectations are as follows: - Ability to extract following details: Customer details, Sales data, Subscription information, and specific SaaS Measures. - The SaaS measures that need to be included are Monthly recurring revenue (MRR), Churn rate, and Lifetime Value (LTV). - The reports will be expected daily, so proficiency in time management and meeting deadlines is a must. Ideal candidates will have a solid background in SQL, experience with Stripe Sigma reporting, and a detailed understanding of SaaS metrics.

I'm in need of a freelancer skilled in PDF manipulation to assist me with editing text and adding or removing pages in a PDF primarily intended for printing. The text edits are simple, mainly spelling corrections. Key tasks include: - Editing spelling mistakes in the text - Add or remove pages as needed Ideal candidates should have ample experience in Adobe Acrobat or similar, with a sharp eye for detail, specifically in spelling corrections within the document. Prior experience in projects involving PDF modifications for printing is a plus.

Hello, We are looking for a freelancer or a company to audit and secure our Microsoft Exchange Server 2019 installation. We favor freelancers or companies with Microsoft certifications and similar experience in auditing and securing Microsoft Exchange Server 2019 installation.

Hello, We are looking for a freelancer or a company to audit and secure our Windows Server 2022 installation. We favor freelancers or companies with Microsoft certifications and similar experience in auditing and securing Windows Server 2022 installation.

i have 3 different date format for created,closed and open vulenrabilties i want open vulenrabities to be looked like line chart nad created,closed to be bar chart have lod calculations for all of them created but cant get it format attached here. its just one chart ,i feel its easy task for expert . if you have worked with similar level of problem kindly ping me then only open vulenrabilties is : SUM( IF [Created] <= DATEPARSE('yyyy-MM-dd', STR([Report Year ]) + '-' + STR([Report Month]) + '-01') AND ([Closed] > DATEPARSE('yyyy-MM-dd', STR([Report Year ]) + '-' + STR([Report Month]) + '-01') OR ISNULL([Closed])) THEN 1 ELSE 0 END) created vulerabilities : COUNT( IF [Status] = 'open' AND DATETRUNC('m...

More details: We require a data scientist to obtain Financial Stock Market data and create a SQL data base to analyze the data with visualization, Algorithm development and optimization We want to analyze current and Historical stock market data.

I'm looking for an experienced professional to setup Azure Data Lake (ADL) or my SQL server and integrate it with Tally ERP. **Key Responsibilities:** - Configure Azure Data Lake or mySQL server for data storage and management. - Setup real-time sync of data from Tally to ADL. **Volume of Data:** - The ADL should be capable of handling and storing less than 1 terabyte of data. **Tally Integration:** - The data to be synced includes invoice details, inventory records, and financial transactions. **Ideal Skills:** - Prior experience with Azure Data Lake setup. - Knowledge of Tally ERP and its functionalities. - Experience with real-time data syncing.

We are seeking an experienced individual to provide monthly website maintenance and support for a group of our websites. In total there are (6) Wordpress websites. There will not be much edits needed each month, mostly just maintenance and optimization, and health upkeep. We will need a monthly report that includes the following 1. Analyze Website Performance and...websites. In total there are (6) Wordpress websites. There will not be much edits needed each month, mostly just maintenance and optimization, and health upkeep. We will need a monthly report that includes the following 1. Analyze Website Performance and speed 2. Test Website Forms 3. Check image quality 4. Backups - Monthly 5. Security 6. Check Website Links 7. Confirm that all content is up to date Monthly budg...

I urgently require a SQL query for my php code. It should basically delete rows from two tables

...integrate with Active Directory (AD) on Windows Server 2022 for user authentication. Details: ====== We have a functioning Squid v4 installed on a Debian Linux Bullseye server and need an expert to adjust its authentication settings. The essential requirements for this project are: The ideal freelancer for this job should possess: - Deep knowledge and robust experience in Squid v4 deployment and configuration - Familiarity with Windows Server 2022 - Proven track record in integrating Squid with AD This task is very definitive and can be just a few minutes if you are familiar with this. The Squid server is essentially working with the Windows Server AD already because applications on Windows clients can already connect to the Internet via the Squid ...

I am looking for a talented website developer to rebuild my current web site and bring it up to date. Key Features & Functions: - Approachable and professional design - Easy navigation around site - Clear and direct contact options Ideal Candidate: - Extensive experience in developing informational websites - A strong understanding of design aesthetics for professional audience - Proven track record of creating sites that drive user engagement, particularly in contacting for more information.

I am looking to create an engaging, interactive online course for Personal Support Specialist training. I already have the content, I just need it turned into a dynamic educational tool. Key requirements: - Integration of my existing con...will possess the following: - Strong experience with online course creation, maybe interactive courses - Ability to implement system for video monitored tests - Background with creating interactive quizzes in an educational context. every student needs to be able to complete the course over a specific period of time from the initial start. None of the students will likely have the same start date. Reminders need to go out to the student as well as their employer. Student progress should be able to be observed by us as they go throug...

I'm seeking an SEO expert and talented content writer who can effectively enhance the visibility of my website on a national scale. This project requires: - Generating 400 backlinks per month from domains with a DA more than 20. Techniques for generating these links should include guest..., etc) - Creating a unique article of at least 1 full A4 page every month, which I would need to preview for approval in the first week of each month. - Providing weekly reports and a comprehensive monthly report, which would include current and previous weeks ranking data. Ideal candidates should have solid SEO and content writing experience, and should be up-to-date with latest link-building strategies. Strong communication skills and a keen eye to detail are paramount.

I'm in need of someone skilled in WordPress to perform a site...bot-generated images from my media library. Here's what you need to know: - These images were generated due to bot comments resulting in broken links, slow page loading, and error messages. - The bot-generated images don't have a specific filename prefix, specific date, or metadata tag to identify them. - One of the plugins also stopped working correctly and needs to be fixed The successful freelancer should be proficient in WordPress and adept at troubleshooting this kind of issue. Your task will be to migrate the site to another server and delete these images to streamline the site's performance. This project requires a keen eye for detail and strong problem-solving skills. Please provide ...

...- The scraped data should be stored in an MS SQL format. - The data needs to be scraped continuously (Every second), on an ongoing basis. Nature of Work: - Retrieve Data continuously (Every second) & update in to MSSQL - Add option to change MSSQL login & pwd details. Also Auto save the details in application - Attached Screenshots for Reference data Tables - Retrieve data continuously (every second) from below url's ,69,1081628,160,1,49776&curr-name-color=%230059B0&fields=15m,1h Gold & Silver Ratios Data from Kitco url (attached screenshot) : Skills and Experience: - Proficient in web scraping techniques and tools. - Experience with MS SQL databases. - Strong knowledge of data management

1) Continue on previous projecName existing api to: api/v1/log/post 12 New api: api/v1/log/get-time/<Serial> • For instance, api/v1/log/get-time/12344 • Returns unix time from Redis, 0 if not exist 3) Add customizable numeric return value for API functions • log_data TO log_user; 8) Change JSON to: {"serial": "AB10", "sequence": 23} and add a sequence field in the table. Sequence shall be a “small integer” – two bytes. 9) Change log_data to a hyper_table, may affect table structure. 10) Maintain a “” script with all initialization etc. 11) Restructure user/database is intended to safeguard for SQL injection? Do you also propose to sanitize strings before createing RAW SQL? 12) Provide s...

I'm seeking a proficient landscape designer that specializes in creating modern, up-to-date outdoor spaces. The project involves transforming a residential space, adding a harmonious amalgamation of water features, outdoor seating, and garden paths. Key requirements include: - Proven experience in modern landscape design, particularly with residential projects. - Knowledge in integrating water features, outdoor seating, and garden paths seamlessly into the design. - Ability to work within budgets and timeframes. I look forward to working with a designer who can respectfully bring my vision to life, ensuring function and beauty in every detail.

...folders in my Inbox to a CSV file. This was written once before using the old Thunderbird API, we just need it updated to work with the current version of thunderbird. Here's a link to the old CODE... • The specified mail folders I want to handle are Personal, Work, and Projects. • The information that I want to export includes the Sender's name and email, Date and Time, Subject, Message Body, and all of the relevant content headers. • The desired resulting document is a well-formatted CSV file. The ideal freelancer for this task has deep understanding and experience in Thunderbird's architecture, .CSV manipulation and custom utility creation. Understanding the mechanisms of email headers and relevant email terms will be another bonus point for ...

...Laravel and hosted on a server running aaPanel. Our site is currently facing problems that could be attributed to both server configuration and Laravel application errors. We urgently require a skilled professional with expertise in Laravel, PHP, and server management to diagnose and fix these pressing issues. Key Issues: Persistent Error 500 on Login: Users are greeted with an Error 500 upon attempting to log in. A page refresh reveals the control panel, indicating a potential session handling or server configuration issue. Image Upload and Admin Panel Malfunction: Neither admins nor users can upload images. Admin Panel: No changes made in the admin panel take effect it shows no error, it behaves as if it did it. This could be server or code rela...

I am looking for a Word specialist to help accomplish a task. This task includes: - Adding page numbers and the date on a Word document. These elements should be placed directly in the center of the footer. - The date must be presented in the dd/mm/yyyy format. The perfect candidate will have a solid history in editing and formatting Word documents. In-depth knowledge of the platform's headers and footers functions is also a must. Attention to detail to ensure proper placement and alignment is also key. Please, when bidding, provide examples of similar tasks you've handled in the past. Thanks!

I am looking for a script to automatically add 7 days to a date in a table. The date format is dd/mm/yyyy and the date is located in the column "Not done late +35D". The result should be a new column with the date + 7 days, called "Not done late +42D". Specifications: The script must work on Microsoft Word. The script must be easy to use and does not require any programming knowledge. The script must be compatible with recent versions of Word (2013 and above). Example:

Hi we have upgrade opencartion dont know what happened due to some module issue site taking over load on server so we need someone to fix that

...predefined data into the respective fields upon activation within the event template section. 2. Ensure no spaces exist between the different data fields, maintaining format consistency. ### Implementation Steps 1. Identify fields within the event template section for the auto-fill feature. 2. Develop the auto-fill logic to insert predefined data without spaces between fields. 3. Implement checks to remove spaces in predefined templates. 4. Integrate the auto-fill feature into the event template creation and editing workflows. ### References This feature enhancement seeks to improve user experience and data consistency in event management systems without specific existing page references. ## Testing Criteria - Correct auto-fill of predefined data into template fields without m...

I'm looking for a freelancer with a knack for DaVinci Resolve to bring my released YouTube health videos to life. You'll edit my content into engaging, faceless videos running 5 to 10 minutes each. Skills and Experience: - Mastery in DaVinci Resolve - Experience with health-related content - Proficient in producing professional voice-overs. Your task is not only to remove the odd slip-up but also to inject new life into my videos with your stellar video editing skills and professionally toned voiceover. Candidates should have previous experience in similar tasks, and old samples of such edited videos and voice-over are appreciated.

Hi I need soneone who can edit my theme code to Add a Logo and remove a picture on each product page (as per the pictures) Shouldn’t take an expert more than 5-10 minutes.

...developer who can accurately commit our blockchain to Ethereum-list/chains. Responsibilities will include: - Committing our blockchain to ethereum-list/chains accurately following the given procedures. - Creating a pull request which in sync with Ethereum List/Chains format. The adherence to Ethereum List/Chains format is a must, as it helps maintain consistency and understandability. - Keeping up-to-date with the latest industry practices and ensure our working model is compliant with the advanced blockchain techniques. The ideal freelancer for this project is proficient in blockchain development, with thorough knowledge and experience with ethereum-list/chains. They can meticulously follow the specific Ethereum List/Chains format. Understanding technical aspects of blockchain...

I currently have a SQL Server database running on an on-premise server and I'm seeking assistance to back it up on Google Drive. - Experience with SQL Server DB management is essential - Comfortable working with on-premises servers and transferring large files offsite - Familiarity with Google Drive storage and its integration with server systems - Ability to guide and advise on maintaining backup processes moving forward. Your expertise will contribute to securing our system and ensuring data protection. Regards

I'm in need of a video editor who can efficiently remove all text and titles present in my 2 videos (both just around 5 minutes long). Your task will be to carefully remove all on-screen text or title overlays from the video without affecting any other display elements.

Currently, I'm in search of a SQL administrator who can help me set up Tableau

Seeking a comprehensive Laravel Debt Collection system equipped with various key features. These include: • Client Management: The ability to monitor and manage my clients effectively and in a user-friendly manner. • Debt Tracking: Capable of not only tracking debts related to individuals, but also furnishing details such as amount outstanding, due date, and history of payments. Any experience in making such systems would be beneficial. • Payment Management: An efficient system to manage payments is essential. Freelancers who have built such systems in the past would be preferred. • Mpesa SMS Voice: A crucial feature is Mpesa integration, which includes receiving payment notifications, sending payment reminders, and sending payment confirmation. Experience in...

Basically: I'm trying to set up a simple way to display a single application on Windows RDP to my customers. Let's say - I only want them to be able to see this program, and I believe it can be done with Apache Guacamole. So if we set this up, I can test, but I'm having trouble configuring it completely. That's where you come in. Set up Apache Guacamole on Windows Server 2022, in a way, that I can reproduce it for all my other customer servers.

...Excel skills for improved data management and analysis within our projects. Responsibilities: - Conduct live coaching sessions in Malay for a group of employees at times agreed upon with the team. - Provide a comprehensive syllabus or course outline that covers all aspects of Excel data management, -from introductory concepts to advanced techniques. - Ensure the course material is engaging, up-to-date, and relevant to our industry-specific needs. - Offer interactive sessions that encourage participation and practical application of Excel functions and features. - Provide assessments or tests at the end of the course to measure the improvement and understanding of the team members. Requirements: - Fluent in Malay, with strong communication and instructional skills. - Extensive e...

We have server with windows server 2012 installed, recently we uninstalled DNS role from the server but just after connection issues have raised. It can ping the IPs but cannot resolve the names. Requiring assistance to remote connect and solve the name resolution problem on the server to reconnect it.

Hi, we have our server down due to an error on the DB. DB query failed: SQLSTATE[HY000] [2002] Connection refused MariaDB is offline. We are using Plesk. We are requesting restoration and maximum attention to the DB. Please note that we do not "open" Milestone. Payment is only made upon perfect resolution.

I am seeking a skilled IT professional with specific experience in migrating data between servers. You'll be tasked to efficiently transfer file data from a PHP server to a new PHP host server. Your key responsibilities will include: - Analyzing the existing server environment and defining the most effective migration strategy. - Conducting the data migration, ensuring the integrity and security of the file data. - Verifying and testing the data on the new host server post-migration. The ideal candidate should possess: - Strong experience in server data migration (specifically on PHP servers). - High proficiency in handling file data. - An understanding of IT security protocols to ensure data safety during transfer. - Ability to troubleshoot any...

Hello looking to developp some simple application under ios and android . fidelity card . I m looking for a simple application ; client can download to get their own account number with bare code after register on their phone to show at payement counter . . Each time client come to shop they show their barecode to the pay desk coun...client email and reduce time to pay desk . it s really light member card . only name on it , and bare code and logo company . that is all . For the back office when they register for the member ship we get name and so the bare code we can enter into our data base of their name if already exist or create a new customer profile with all data . when register it will have name ; last name , birthday date , phone number . ...

...management - Strong understanding of content planning and project management - Ability to create a cohesive structure with consistent statuses across boards - Excellent communication skills and attention to detail **Scope of Work:** 1. **Content Backlog**: - Develop a database for content ideation, planning, and tracking. - Must include properties such as title, status, category, publish link & date 2. **Recurring Tasks**: - Set up a system to remind me weekly to work on content and plan my tasks. - Include a method for tracking completion and upcoming tasks. 3. **Tasks for Specific Projects**: - Create separate task boards for 'Piece' and 'Tentu Saja', ensuring consistency in task properties and statuses. 4. **Personal Tasks**: - Im...

...it's crucial for the writer to have a thorough understanding and genuine interest in the subject matter they choose to write about. - Familiarity with SEO best practices would be an added advantage. Skills and Experience: - Excellent written communication skills - Past experience in writing informative articles - Strong research skills to ensure all articles are accurate, comprehensive and up-to-date - Familiarity with SEO best practices would be beneficial....

Budget is strictly AUD $2/ hr I am in need of a talented graphic designer who can also serve as a virtual office admin assistant. We'll be focusing mainly on web research specifically data collection in the fashion industry. Key Responsibilities: - Gathering and recording up-to-date and detailed fashion industry data through comprehensive web research. - Converting data into usable information for our design team. - Web graphic design for online platforms. Ideal Candidate: - Proficient in Graphic Design particularly in Web Design. - Experience in Data Collection and web research. - Has a good eye for fashion trends. - Great administrative and organizational skills. - Effective communication skills. Your role will be integral to our operations and your graphic design talen...

Milestone 1 | Result: Initial deposit: released after acceptance of the project Delivery date: 3/25/2024 12:00 AM - Revisions included: 0 Price: 200 USD Milestone 2 | Result: First submission: 1st 6 renders preview Delivery date: 4/2/2024 12:00 AM - Revisions included: 1 Price: 500 USD Milestone 3 | Result: Final submission: final renders + arial take Delivery date: 4/5/2024 12:00 AM - Revisions included: 1 Price: 100 USD Total budget: 800 Currency: USD

Milestone 1 | Result: Initial deposit: released after acceptance of the project Delivery date: 3/23/2024 12:00 AM - Revisions included: 0 Price: 200 USD Milestone 2 | Result: First submission: 1st render preview Delivery date: 3/29/2024 12:00 AM - Revisions included: 1 Price: 500 USD Milestone 3 | Result: Final submission: final renders + arial take Delivery date: 3/31/2024 12:00 AM - Revisions included: 1 Price: 100 USD Total budget: 800 Currency: USD

I'm searching for a seasoned web designer to create add-on 10 pages to an existing Professional Deep Cleaning website. an intuitive, engaging, and informative pages. It is crucial that this site appeals to a wide range of audiences. The website will contain a few specific pages. Specifics: - Home Page - Add on Services with sub drop ...Solid experience in creating wireframes, storyboards, user flows, process flows and site maps - Proficiency in Photoshop, Illustrator or other visual design and wire-framing tools - Excellent visual design skills with sensitivity to user-system interaction - Ability to present your designs and sell your solutions to various stakeholders - Ability to solve problems creatively and effectively - Up-to-date with the latest Web trends, techniques, an...

...excels in Excel to carry out some basic data entry tasks of 7 columns in 75 rows. I attach the excel sheet. Please note that you will get the information from the first page of the reports attached here. The pdf file name is the project id identifier. Note: appraisal_complete is basically closing date appraisal. You don't have to add any additional information apart from the ones I asked for in the excel. In essence, you will be entering numeric and date data, with formatting required for the date data. This task is simple, therefore no complex formulae or data validation will be needed. Ideal skills and experience: - Proficiency in Excel - Attention to detail - Experience in data entry This should be a straightforward job for someone with the above skil...