673,934 questions
1
vote
1
answer
63
views
Informix 12.10 CLOB & RegEx bug?
I am running Informix 12.10 on several Windows servers. I have a simple table. For brevity, let's say the following. I am storing a name, a couple of numbers, the mime type, the actual file/media, ...
- 35
Advice
0
votes
4
replies
64
views
Table Dependency
Let's say we are adding new column in a table and we have to find which stored procedure is using that table so how to find in below
SQL Server
Sybase
- 1
Best practices
0
votes
4
replies
94
views
How to Show Whether a Task Row Is Currently Locked by a Worker
I am building a worker system where idle hardware is expensive, so machines need to pick up new tasks as quickly as possible.
Task durations vary significantly: some take a few seconds, others several ...
-1
votes
1
answer
111
views
Find continuous date range over multiple rows [closed]
I'm having an issue combining the records for the following table. There are multiple rows for data ranges, but they are actually continuous so I'm trying to combine them to find the maximum ...
0
votes
1
answer
94
views
Using a SELECT alias inside HAVING
I'm using Apache IoTDB 2.0.8 in table model. I need to filter grouped aggregate results, so I tried to define AVG(voltage) once with the alias avg_v and reuse that alias in HAVING.
Schema and original ...
8
votes
3
answers
277
views
Grouping text rows in equal-sized groups
I have a table containing a lot of typed/named items and I want to create a (materialized?) view to group them together so that a UI can later make it easier for users to select.
Description
The goal ...
- 4,310
-3
votes
0
answers
79
views
Stored procedure testing query [closed]
We are testing a stored procedure that performs insert, update, and delete operations between a source table and a target table, each containing 100+ columns.
As part of our test cases, we are ...
1
vote
1
answer
101
views
MySQL Case Function
What is wrong with my query?
CREATE PROCEDURE process_flight_log_staging_doug()
BEGIN
UPDATE `flight_log_staging_emt` SET `off_z` =
CASE 'offz'
WHEN `off_tz`='EDT' THEN `off_lcl`+INTERVAL 4 HOUR
...
- 151
0
votes
1
answer
132
views
JOINING three tables using subquery with MAX date [duplicate]
I have three tables, orders, invoices and invoice lines.
uid OrderNumber product_id product_name quantityOnOrder
1 101 p001 Apple 6
2 102 p002 ...
Best practices
0
votes
9
replies
188
views
SQL query for adding two numbers
I am trying to write a basic SQL query that adds two numbers together. While the core arithmetic is straightforward, I want to make sure I am using the standard approach that works across different ...
3
votes
4
answers
163
views
SQL Sum Aggregation
Data Set
animal
legs
parrot
2
chicken
2
dog
4
cat
4
c'thulu
999
missing'no
0
Goal
animal
legs
bird
4
mammal
8
I'm not sure what's wrong with my Oracle SQL query. It doesn't seem to be aggregating ...
- 33
-1
votes
1
answer
104
views
In SQLite with DBeaver Transaction....Commit is not working
I am using SQLite with DBeaver. I recently got a university assignment where I was asked to show the locking mechanism of a database. So I decided to work with DBeaver.
I can solve it properly with ...
- 86
1
vote
3
answers
155
views
Use GROUP_CONCAT as a condition
I'm creating a query where I have a box, and it has multiple products. I want to check whether any of the products' product_numbers can be found on the addons table. So I initially made this query:
...
- 21
0
votes
0
answers
179
views
Is a fast-return possible when parameter value not provided [migrated]
I've got a query looking for accounts against the user-provided input:
SELECT * FROM accounts a
WHERE a.dep_id in :depIds
AND (
(a.key_identifier IS NULL AND a.name LIKE CONCAT(:searchText, '%...
- 4,716
Advice
1
vote
3
replies
156
views
How should I structure a beginner WPF Bicycle (class) app with multiple windows and MySQL integration?
I am currently learning WPF (C#) and trying to build a small Bicycle Management application for practice. I understand the basics individually (WPF controls, simple classes, MySQL connections, etc.), ...
user32755268
