Problem This function code works very slowly. How can I speed it up? CREATE OR REPLACE FUNCTION bill.”ReportIngredients”( _from date, […]
Category: SQL
T-SQL Hmac (Rfc2104 SHA2_256) Implementation
Problem I’m trying to implement an Hmac in T-SQL using this question as an guide. Please critique this: create function […]
Find first questions with answers posted within 24 hours
Problem So, sᴉɔuÉɹɥԀ suggested I write a SEDE query to find first questions with answers posted within 24 hours, and […]
Has the following query been made in the optimum way?
Problem SELECT p.name,m.name FROM parts p INNER JOIN Manufacturers m ON p.man_id=m.id ORDER BY p.name DESC If not, what should […]
Basic SQL user database [closed]
Problem Closed. This question is off-topic. It is not currently accepting answers. Questions containing broken code or asking for advice […]
Build a string for a search query
Problem I am building a string for a search query and I think I am doing it the wrong way. […]
Length limited listagg for muliple m:n relations in a view
Problem I have a few views that all follow the same pattern. They select a primary key from some main […]
Query to find instances of two types of events occurring more than one second apart
Problem I have 3 tables on my database: BusinessObject and CustomEvent, and EventType. BusinessObject having a lot of columns, CustomEvent […]
Multiple input fields from PHP table
Problem To summarize from a previous question, the user selected a starting date, an ending date, and a region. From […]
DB2 statement to update a header file if no corresponding record exists
Problem I have written below SQL in an RPGLE program. Intent is to update the header file (TC400F) if no […]