The problem: on C#, MVC API with Angular 6 front end on IIS deployed solution. A simple HTML table with 8 filtering fields on specific columns runs queries on the back-end through an API HttpGet call. The function itself works ok, but NOT for specific strings. On the field ‘Description’ for exampl…
Tag: sql
SQL optional parameter
I’m struggling to set optional parameter in MS SQL 2017. It should do: If parameter is null, then ignore the condition, but apply other conditions If parameter is set, then apply the condition …
Comparing group-by result with aggregated result
I am trying to retrieve details about stores where their average product prices are higher than the average of all stores in the table. So far, I have this code: select StoreID, count(ProductID) …
postgres jsonb update key value in array
I have a table with a jsonb column with data from one row like [ { “a”: [], “c_id”: 624, “ps”: [{“”: 0, “pr”: “73”, “f”: “M”, “s”: “M”}], “g_n”: “K L Mish”, …
for each on post from form not submitting correctly
I am trying to loop thorough a form and submit the values to the database. It seems to work, except for that it tries to include the submit button itself into the database and so throws an error (as …
SQLite3, Combine multiple rows in one
I have two tables cities (as C) and routes (as R) C: ____ ______ | id | city | |____|______| | 1 | A | | 2 | B | |____|______| R: ____ ______ ____ __________ | id | from | to | distance |…
UPDATE with INNER JOIN on SQL Server
I have 2 tables Users and Orders. Primary key of Users is UserId, which I have defined as foreign key in the Orders table. I have added a new column of UserName to Orders. I want to import UserName …
SQL group by is bringing lots of duplicates
I’m trying to group my data by OccDate, ParkingContextType, AuthorityId and of course, i would like to measure each sessions for each date/contexttype etc… However, I`m also trying to calculate the …
How to know the size of a table with a photo in Oracle
I have a table that I fill in the post method, I send a photo, and describe the event, I want to know the size of this table (MB) with the help of a selector, Someone can help me with this ?? SQL> …
how to return a unique set of characters within a field (SQL)?
Basically i am trying to return any fields within the tag column that contain up_ up1_ up2_ up3, up4_. the problem i’m facing is i only want to show these tags and not the others. The field …