... 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.
...Charming Baker, Banksy, Wilhelmina Barns-Graham and so forth). After this, products should be sub-sorted by stock level as before. The idea here would be to create a custom query that is only used on the store page (and would be set up on the Theme's [url removed, login to view]). Hope someone can assist with this, and I will very much look forward to hearing from
...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 need sql server expert with following skills . • Experience with all versions of SQL Server from legacy SQL Server 2000 to SQL Server 2016 • Core database administration skills (day-to-day administration, configuration) • Suggest / make changes to improve database performance ( create indexes etc ) • Full understanding of SQL Serv...
I need help with exam questions for my upcoming test. I would like someone to go through SQL, Relational algebra, Query processing, File organisation and ER diagrams. I need this help today. Looking for someone who can start straight away.
Retrieve a complete list of all Categories, Sub Categories, Sub Sub Categories, etc. in only one SQL query only simple code by php and mysqli I need dropdown list like this main cat1 -sub cat1 -sub cat2 --sub cat 1 --sub cat 2 --sub cat 3 ---sub cat 1 ---sub cat 2 --sub cat 4 -sub cat3 -sub cat 4 main cat 2 -sub cat1 -sub cat2 --sub cat 1 --sub
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
...sorting. Can see an example in this query… [url removed, login to view] 38 different operators start with "dev." The idea is an end user types "Devon" and is very surprised there are 38 different ways to say that operator name. How would one ever search on Devon projects (without being a SQL person – with wildcards and starts
[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 ...
Hi all, I need someone to complete a uni assignment about cinema website. It is an [url removed, login to view] MVC Core Web Application using Visual Studio 2015 and SQL Server 2016. Users can check movie session times and book movies. My budget is 80 AUD. Expected completion time is 4 days. ********Completion time is very important so do not bid if you cannot complete
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