I want to show different contents to readers from different countr...So the url will be like this [url removed, login to view], where country is the name of the field and ZAR is the value. What you will need to do is to write a code that will query the database based on the url parameter. It will filter the value submitted in the url via GET method.
... data type, and description. There will be 133 fields in the data file. The data file does not contain header files, which will need to be pulled from the layout file. The query will use the layout file to create the headers for the data file, and also replace any codes to human readable descriptions (from layout file). Attached are samples of the layout
I would like to be able to use a cell as a parameter for and OData Feed URI. So when the user changes the value, we refresh the data and the OData Feed will update the table.
...Image (varbinary(max) - this one is empty. I want a query that will work on my SQL Server 2016 that will update all the ImageUrl with a binary of this image. This binary must be able to be read/loaded in a [url removed, login to view] application and displayed in a pictures Box The task here is only to provide query/function that will fille this table as specified a...
Dear sirs, I need a update query for a table. The fieldname 'ex-value' must be set to 0 (zero) if the record 'id' occurs multiple times. The first time the id occurs, the value must not be changed. In this sample 'id' occurs several times thats why de 'ex-value' is in the sample table after running the update query is 0 (zero). Kind Regards...
We require to sql queries to create database view: Emp ID, name, add, dob, phone, email, tfn, total weekly pay, total weekly tax Emp ID, name, add, dob, phone, email, tfn, weekly pay, weekly tax. Between 1 july 2016 and 30 June 2017
[url removed, login to view] I would like this re-written so that i can use it in Python to query the API for Flick energy
i have three tables i want help to get most recent record from table C, here is my query giving me first record $query=mysqli_query($con,"SELECT a. * , b . *, c.* FROM empMaster a, PUnit b , department c WHERE [url removed, login to view] = [url removed, login to view] AND [url removed, login to view] = [url removed, login to view] GROUP BY empid ORDER BY [url removed, login ...
I'm in search of steps to accomplish the following. I have a monitoring API query that returns response body containing a value between 0 to 100. I want to create a SharePoint list field that will store the value that API call. For instance, imagine I have a SharePoint list of 3 rows. Row 1 calls the API and returns the value 90 Row 2 calls the
From a mysql table orders_history, calculate the weekly moving average...experience in similar project. Will provide sample table schema and data on request. The current data i have contains over 1million rows so the query needs to be optimised. I have successfully written a query to give me the weekly average, now I would like the moving average
Hello folks, I am working on a procedure where I have to replace internal table named tt_series with database table named db_week_series to improve performance. I have to add some functions for replacing internal table which I am not able to figure it out. I am attaching my procedure here. Please have a look.
Módulo Python con los siguientes procesos: Python module with Following processes: Create xml from invoice. Consume web services: stamped and canceled. Create pdf report of web service response (stamped).
...PHP mysql query to get the counts for specific games based on the games id. Example: The table holds multiple games, each game is identified by the gameid. The client wants to create a query statement that will get all the games and gameid from the database then display the specific count results for each game without creating so many query statements
...build now a SQL query that shows me as a result the whole context with its text from the second table. This result have to be written as html page with php 5.6 Attached you will find a dump of the two tables. This only contain some sample data. The database do not contain “WITH” statement so it have to be solved another way. I expect SQL scripts