...position (in %) on basis of each shareholding with MySQL table. If position exists at same level (%) do nothing, otherwise add new entry. After finished, send email via SMTP with changes if any, otherwise no email. Basis of this will later be pythonanywhere that hosts the script and the MySQL database. A cronjob will run the script once every
Precisamos de um especialista em SQL e Query em SQL. Temos um site desenvolvido em PHP (sem framework) onde ele realiza algumas querys em SQL. Entretanto, os bancos são BEM pesados (cada banco tem em torno de 500mb, com 2 a 3 milhões de linhas) e isso está tornando o site um pouco lento. Precisamos otimizar essas querys e o banco de dados, seja na utilizaçã...
Hi, I have a query function in a column that gets a currency exchange value from a date in column A. I would like a script that overwrites the query function in this column and control pastes special values of the data when the query function has been activated. The reason for this is there are about 40 entries per day in this column. Ive noticed
create sockets----- server and client side and connect to database at server side and in the client side create GUI implement query to access data from database and send to client using socket
I need a query for get some informations from Ms Sql, but for privacy requirements, i can't give you access to datatabase. However i can give you two queries that working right where you can get the table names required ------ Select MGGiacDisp.Cd_AR,[url removed, login to view],cast(format(Sum([url removed, login to view]), 'N', 'it-it') as varchar(20)) AS ...
...very complex SQL query for one of my programs, and I am trying to see if there is anyone who can optimize the speed. Currently, the query takes 3 minutes, and the total execution time I have to complete my processing is 5 minutes (the overall process is on a 5 minute cron job, so the SQL query takes the majority of the time). The query is very long so
I need google app engine script which will query 1000 tables (500 to one destination, 500 to second destination table). Store information about jobs, have option to check report which queries are done, which has errors and retry failed jobs.
I am looking for expert who is really good in advance excel, Microsoft Power BI stack - Power Pivot, DAX, Power View, power query, power Map,VBA Scripts, Macros, OLAP cubes, MDX and Tableau Visualization Tool.
Hi i have most of what i need set up but need some additions 1. multiple child row array set up 2. slide effect on the row 3. loading table before stylesheet so looks weird 4. filter child row as well As i said, its pretty much all there. no styling requireed
Hi, Here i am getting this error in my application. I didn't understand the solution, so i need your help