In my MariaDB environment I want to check to see if there are any values in the table “contacts” and the column “firstname”, where the first letter in the string value is lower case. My question is: …
Find all tables with a specific column name + where value is lower than X
I need help in searching our database. So we have this problem that we need to know all tables, with the column_name “sysmodified” and see if there are any entries before a specific date (25-sep-2019)….
SQL delete duplicate rows based on multiple fields
I have the following table in sql: id | trip_id | stop_id | departure_time —————————————- 1 | 1| 1| 06:25:00 2 | 1| 2| 06:35:00 3 …
How to handle umlaute like Ä Ö Ü in Coldfusion SQL query to insert into database?
I want to insert a string into my database with Coldfusion. However it contains umlauts like Ä, Ö and Ü (German). The umlauts are displayed different than they should in the database. For example I …
How to combine same result into one row after inner join in LINQ
I’m new in ASP.NET and LINQ. I want to display book name, publisher name, and author name in index page. One book can have more than one author. my query for display the result is like this var …
Calculate differing accumulated storage charges over time?
I am working on a project for a wine importer, in which need to calculate the accumulated storage charges per SKU up to the delivery date. I have data from the warehouse recording the Date_In and …
First date from second table where date is bigger than date in table first oracle
I want pull out the date from second table. My second table may have a over 100 dates to a unique record(A,B,C). I have I first Table : and the second table : I want to first table pull out the date first date from second table when date is bigger than the date1 from first table. The result must
Seed Data using merge statement including data from external table
I’ve been provided an excel file with data that I am supposed to merge into a database. From this data I am concatinating a string in this format: ‘Maastricht’ here is the name of a city, which I need up in a foreign table during the insert. This is the script that I have come up with: To Re…
Perform counting for lookup in SQL
I would like to perform lookup based on the number of Yes in Input. In ID No.1, Output1 is A because it is first Yes, Output2 is B because it is second Yes. In ID No.2, Output1 is blank because Input1 is n/a, subsequent output is based on number of Yes appeared. In ID No.3, it shows counting is skipped
Ajax POST data not appearing in modal
I have a table that’s populated by JSON data. In the last column you can open up a modal that corresponds to each row and you can add a comment in an input box—doing so will update that modal. In …