Sql database schema stored työt

Usealla isolla yrityksellä on käytössään Suomessa eräänlainen heidän alansa ERP-paketti, joka on koodattu Visual Basicillä. Tarvitsisimme VB-osaajaa ylläpitämään ohjelmistossa mahdollisesti tehtäviä muutostöitä. Tekniikka lyhyesti: • Visual Basic -koodia noin 280-290 000 riviä • Integraatio taloushallintoon ja palkan maksuun • raporttipuolella n. 50 000 riviä • Crystal Reports • Microsoftin SQL Server -kanta Työmäärät vaihtelee, mutta keskimäärin 1-2 päivää/viikko. Välillä hiljaista.

Meillä on kaksi yritystä järjestelmässä, joilla on omat varastokirjanpidot ja osto-&myyntitilauksensa. Lokaalina serverinä toimii Windows 7 ympäristössä, visma Nova pro 9 (Windows sql server). Mikäli työn suoritus vaatii jonkin tietyn ympäristön niin kysele. Haluaisimme ajoitettuina tehtävinä ajaa allamainitut skriptit jotka muodostavat CSV tiedostot jotka on tarkoitus lähettää sähköpostina eteenpäin. Skriptin asetusten muokkaus skriptin alussa. Muuttujat ja funktiot kommentoituna. Lisätyönä voi tarjota näiden tiedostojen automaattista lähettämistä (Tiedosto liitteenä + leipätekstissä luettavasti muotoltuna). --------------...

Webservicen luominen sql tietokannalle. Perus toiminnot webservicelle ja kehitys ympäristön pystytys. Tarkempi speksi on saatavilla NDA:n kirjoituksen jälkeen. Kehitys mielellään Eclipse ympäristössä.

Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies the Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is available and the Project needs to be done using Visual Studio. Azure SQL database management and required SQL queries are not in the scope of the Project.

Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies andthe Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is avaiable and the Project needs to be done using Visual Studio. Azure SQL database and required SQL queries are and database management is not in the scope of the Project.

Excel Add-In joka hakee ja tallentaa taulukkomuodossa olevaa dataa Azure SQL-kannasta/-taan. Lisäksi ohjelmallista Excel muokkausta ja hallintaa C#-koodilla. Osaan Excel muokkauksista valmis VBA-script, joka muutettava C#-kielelle. Visual Studio 2015 alkukoodi, SQL Azure tietokanta ja kyselyt valmiina.

Java, J2EE, JDBC, SQL, java Threading,GWT,Html,CSS

Moro, Mulla olisi sulle työtarjous! Jos voisit tehdä mulle simppelin tietokannan ~5 taululla, ja kerrot vähän perusjuttuja sql serverin toiminnoista jne, niin ota yhteyttä ja jutellaan tarkemmin. Arvioisin, että tässä ei montaa tuntia menisi. Riippuen toki kuinka hyvin nuo sql perusjutut osaat ;)

Moi! Osaatko kuinka hyvin sql:n perusasiat? Onnistuuko asentaa tietokannan hallintajärjestelmä, luoda ja hallinnoida tietokantoja sekä käyttäjätilejä ŠŠ ,seurata ja optimoida tietokannan toimintaa. Jos perusasiat hoidossa niin ota yhteyttä :)

Moro, Mulla olisi sulle työtarjous! Jos voisit tehdä mulle simppelin tietokannan ~5 taululla, ja kerrot vähän perusjuttuja sql serverin toiminnoista jne, niin ota yhteyttä ja jutellaan tarkemmin. Arvioisin, että tässä ei montaa tuntia menisi. Riippuen toki kuinka hyvin nuo sql perusjutut osaat ;)

I will share my screen and show you my organizations databases and tables. I will need to extract some specific information from the database. Should be very easy for you if you're an SQL expert. Simple JOINS may solve it.

...processes data / (SQL statement) forwarded from multiple PLCs and then commits it to the PostgreSQL database on the cloud. (DigitalOcean) - A module that feedback ACKnowledge code back to designated PLC to confirm the committed records. - a deployable program in Windows 10 environment with meaningful settings such as managing PLC device records, PostgreSQL connection param etc. - any requirements that are not listed while the project is proceeding, and those requirements are relevant to determine project success. - Whereby the PLC able to query data from the Database to get relevant machine parameter data; PLC to update latest machine parameter data up to database. Usecase scenario 1- PLCs to commit sensor data back to Database 2- PLCs to query machin...

All problems are listed in the attached document. I just need 5 queries written in relational algebra.

Hi, we have a magento 2 site. i have create copy of live site and copy db and past files into vsf (vuestorefront) and db install. but i have prolbom with getting erorr solution is "SET GLOBAL log_bin_trust_function_creators = 1;" but it showing access denied ERROR 1227 (42000): Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation. the work is to make test site work with vsf2 files that have already been done.

This app is to maintain the store cards for the user. User could enter card number (alpha numeric) manually or scan the existing card to add to app. Generate Liner Code-128 barcode image (png/gif,jpg,svg) and add to the app. App should work offline. All data stored locally on device for now. Please don't bid without reading document

...las consultas que sea realizan a esta mediante excel. * Migrar la BD a alguna instancia en algun servidor Cloud (No poseo ninguna instancia contratada, necesitamos asistencia en esto también). * Necesito que los archivos de consulta en excel puedan consultar a la nueva ubicación sin problemas (ver temas de usuarios y seguridad). Es por esto que entiendo la persona además de tener conocimientos en SQL también necesitaria en Windows Server y Servidores. La forma de pago puede ser en $ o Criptomonedas....

Se requiere crear un formulario que lea datos de tres tablas de una base de datos ms sql. El formulario debe pintar en html los datos, dos de ellos son listas desplegables que se deben llenar consultando las tablas arriba mencionadas. Finalmente el formulario debe hacer un update a una tabla e insert a otra y mostrar por pantalla la confirmacion de la actualización. El formulario debe desarrollarse en html5 con la hoja de estilos de bootstrap. Se debe desarrollar con php 7 y base de datos MS SQL server. La conexión hacia la base de datos se debe hacer usando PDO. Los script de las tablas y datos se entregan.

Hi Ismael P., I noticed your profile do you do PHP /SQL I have a startup web software I am looking to finish.

Hi Clecio, I see you are a translator which is great but do you also do programming? I have a project that requires PHP / SQL etc.

I want a small website nothing fancy, watch the video .

Looking to build a website specializing in the aviation chemical industry, we are deciding on 2 different options: option 1. build a sourcing website like which the customers can enter and input the items they are searching for and we will source their requests and get back to them via email. option 2. build a database website such as or in which a lot of part number positions will be uploaded, where clients can search for items, in turn various suppliers will upload their stock and the clients will be able to receive a price either via email or the platform itself. There can be around 100,000 positions up to 1 million positions, depending on how many suppliers we attract. please let us know a rough

I require a simple 5 page website to be developed for a client. A simple database needs to be built with a few tables for this website using MySQL. The website can be coded in HTML, CSS, Javascript, ASP, PHP, or JSP etc. This needs to be a simple build as it is just for presentation purposes and not for publishing yet.

Need help with working on sql server commvault backups.

Hi everyone. I need to implement a Cloud Function in Firebase Realtime Database. The function has to remove the childs inside the node "CODIGOS" if they are older than a week, using TIMESTAMP value. No other nodes in the Database should be affected. I need the code for the and the package.json. My thought is that the function should be activated through a cron job, but if there is another better solution, will be nice to know. The function is for an app made with Kodular, so I don't have any idea of coding. I'll load the zip file you supply and I'll pay when the function is proved and working without problems. I'll try to answer all the question or issues needed for coding. Forgive me if I have already written some nonsense. Thanks.

...buyer's location, app will show partner stores of that particular pincode to buyer on top. Buyer should be able to open any store, will click on any products available on that store, add to cart, proceed to pay and place an order. Once an order is placed, a notification will go to that merchant from which order is placed. a confirmation email and message to buyer also and all orders should be stored in admin panel in sales or order history buyer wise, seller wise, orders wise, earning wise. A notification will go to nearest delivery boy. Delivery boy will accept the order and proceed to seller and collect the order and deliver to buyer. Buyer and seller should be able to track the delivery boy on app. Once delivery boy will mark delivered then that order will be shown deliv...

I have two tables, Sales and Revenue, which are the sales and revenue for each city. please see the screenshot of the tables I need a SQL Server query that gives today and MTD values: * Total number of sales in each city- Today * Total number of sales in each city- MTD * Total Amount in each city - Today * Total Amount in each city - MTD I need these 4 columns in one table with the city column. please see the screenshot of the result table I appreciate your help.

I have two tables, Sales and Revenue, which are the sales and revenue for each city. please see the screenshot of the tables I need a SQL Server query that gives today and MTD values: * Total number of sales in each city- Today * Total number of sales in each city- MTD * Total Amount in each city - Today * Total Amount in each city - MTD I need these 4 columns in one table with the city column. please see the screenshot of the result table I appreciate your help.

I have two tables, Sales and Revenue, which are the sales and revenue for each city. please see the screenshot of the tables I need a SQL Server query that gives today and MTD values: * Total number of sales in each city- Today * Total number of sales in each city- MTD * Total Amount in each city - Today * Total Amount in each city - MTD I need these 4 columns in one table with the city column: please see the screenshot of the result table I appreciate your help.

Ideal candidate will be fluent in Solidity and Javascript and capable of embedding multilayered smart contracts into Non Fungible Tokens. Satisfaction of the conditions of the smart contracts within the token will result in the generation of hashes which will be used as keys to access encrypted media stored off chain. However, of almost equal importance to the technical prowess of the individual will be the energy of the individual. The company envisioned will be very firmly established in the "Work Hard Play Hard" school of thought. Work will, by it's very nature and purpose and design be enmeshed with content, character, and colouer which is...NSFW. No squares need apply. This is a company which will NEVER drug test its employees. There will never be disciplinary ac...

Create a new database in Microsoft office and Edit the same data which will be given in the JPG file. This requires someone who pays attention to details and can fix formatting issues along the way.

Hi Manju D., I noticed your profile and would like to offer you my project. you will create: project in asp.net and sql server in backend - group discussion like skype. - can send file and image to the group - real time update discussion when user post in group - the date and time appear like skype - seen by user - no need to call & video function - the backend must be sql server - the ability to create group. - no need to create user system because when you finish I will add my own user to the groups. - the design look like skype. send the test link in 1 day

Hi Jiru C., I noticed your profile and would like to offer you mI am working on a mini project where a users data (React js web app with authentication followed by details filled by user and submit button)will be stored in the hyperledger fabric and hyperledger fabric will sent a unique key for that particular users data. We can discuss any details over chat.

Hi Julius M., I noticed your profile and would like to offer you my project. I am working on a mini project where a users data (React js web app with authentication followed by details filled by user and submit button)will be stored in the hyperledger fabric and hyperledger fabric will sent a unique key for that particular users data. We can discuss any details over chat.

I build a Crypto arbitrage Trading bot with js and I stored the tokens on a array in a config file and then I loop the tokens to watch for swaps and that wen a swap happens a check de prices I am monitorin uniswap v2 and sushiwap DEXs and then when I try to get the reserve of the tokens I always get the seme value for all tokens, And also I have this exception Error: Returned error: execution reverted: ds-math-sub-underflow when I try to get the amount out.

A simple React js web app containing some details of user and when clicked submit the data is to be stored to hyperledger fabric and a responce of Unique key must be given back to the user.

Full time job in Faridabad, Haryana: Skills Required- .Net , ASP.Net, C# or VB.NET, SQL database.

Database SQL developer needed urgently

My Sql Specialist for urgent task Small Task Budget 20AUD

Need someone experienced in core PHP .. I have 7 boxes in PHP site...there is red colour border coming around 6 boxes but not on one box ..need to put that red border line around that box too . Red border line comes when there is some quantity in "quantity field" of that box . Also one field is not saving ..need to save it too.. Need to get it done asap...

Hello, This is 2 part project: 1. Create a scraper that will scrape information from a website daily and get all the products. And store this information in a database. We already have this partially built, we just need to see if it can be modified. 2. Chrome extension built that is able to pull information from previously mentioned database and display history of price changes for displayed products. Website in question is: Thank you, Kristijan

...developers on contractual basis. Strong working knowledge on Azure development Working knowledge on building integration solutions using Azure products (Log Apps, Functions, Service Bus, API Management, Azure SQL, Blob Storage, Key Vaults, etc) Working knowledge of fundamental Azure services such as Container Technology, storage, identity and access management, Azure CLI, PowerShell Extensive experience in building DevOps pipelines for automating infrastructure and application deployments Experience with related technologies such as REST, SOAP, oAuth, etc. Working experience in ASP.NET, SQL Server, JQuery, Angular and Visual Studio Team Continuous integration (Azure DevOps) and version control (Git) Roles and Responsibilities Understanding Azure services to determine wha...

I need a relational database that I will embed into my WordPress website. I am already working on the site but I need help with the database in order to complete the site on time. Please see the attached document and get back with me.

1. we have a running site with executable php files and static image/videos all hosted in same location, EC2, we are using WHM/cpanels to manage sites 2. lets say our URL is some executable pages looks like and statics are stored in a subdir, and they look like , etc 3. we now run through cloudflare, and EC2 is serving both executable and statics- we want to change here - implement some aws cloudfront, so when we upload images/videos to dir, they should go to aws CDN service, and from then aws CDN should serve those statics instead of EC2, while keeping the URLs same , not https://abcdefkj

need to update one my sql table(feed) based on penname data and get id of table pens (id,penname)and update feed table with idenid

I have an application using Vue + Laravel. I have to run the application using npm run watch When I run this command I got this error message : Invalid configuration object. Webpack has been initialized using a configuration object that does not match the API schema. - [10] has an unknown property 'loaders'. These properties are valid: object { assert?, compiler?, dependency?, descriptionData?, enforce?, exclude?, generator?, include?, issuer?, issuerLayer?, layer?, loader?, mimetype?, oneOf?, options?, parser?, realResource?, resolve?, resource?, resourceFragment?, resourceQuery?, rules?, scheme?, sideEffects?, test?, type?, use? } -> A rule description with conditions and effects for modules. Anyone can solve it ?

System should import excel form, and in output should export with some modifications: Modification . Type of driving column addition . Modification in importing excel for getting the types of driving . Types of driving should get from time and date based on criteria time A and time B from import file Driving during working hours (08:00 – 17:14 every day Monday-Friday) Driving after working hours (17:15 - 07.59 every day Monday-Friday ) Driving during weekend - (from Saturday 00:00- to Monday 07:59)

...back-end portals with an optimized database. • Troubleshooting application and code issues. • Integrating data storage solutions. • Responding to integration requests from front-end developers. • Finalizing back-end features and testing web applications. • Updating and altering application features to enhance performance. PHP Developer Requirements: • Bachelor’s degree in computer science or a similar field. • Knowledge of PHP web frameworks including Yii, Laravel, and CodeIgniter. • Knowledge of front-end technologies including CSS3, JavaScript, and HTML5. • Understanding of object-oriented PHP programming. • Previous experience creating scalable applications. • Proficient with code versioning tools including Git, Merc...

I have a data into the database and i wanted to fetch and display that data into the web with template and survey extension. working fine do routine database calculations and create graphs 1. bar charts 2. Radar chart & 3. scatter graph Project Tag : Joomla, Laravel, Flutter, APPLICATION, IOS,ANDROID. CREATE with this and invite to me.

I want a one software which can get data from SQL or Access and generate data in selected format in excel and PDF. 1) Need a daily Report means every hour data can generate and store it in separate folder in excel or PDF 2) Report will generate automatically at night 12 am and save in separate folder 3) Report will also generate manually by select date to and from. Sample format and database is attached here.

Form Sign up. Charge money. Withdraw money.