I’m creating a branching dialog game, and used a dialog tool that outputs JSON with a link and a link_path to connect dialogs together. I’ve parsed and inserted this structure in PostgreSQL. I want to …
How do I use prepared statements with an OleDbDataAdapter?
I’m writing an API that will query a database given certain parameters. Some of those parameters will be supplied by the calling app (which should be trustworthy), but some of them will be supplied …
Finding the most active video maker within multiple tables(SQLite)
How can I find the initials of the most active video maker, the one that made the most videos considering the following tables using only one query? CREATE TABLE IF NOT EXISTS Videos ( title TEXT …
How to to create a new identifier in SQL for related addresses that have multiple relationships?
I have a data set like below that includes address and customer_id. In this example multiple customers can ship to the same address and a customer can ship to multiple addresses. I would like to use the relationships between these to create a new ID that joins all of the related addresses and customer_id̵…
Is it possible to use dynamic columns multiple times in a select?
I have some complex string replacement and I’m only permitted read-only access. I’d like to have several columns where each is dependent on the previous column so I can see if my substring and …
Find first available value that doesn’t exist
I want to create table for book chapters where pk will be book_id and chapter_internal_number. I’m not sure how find next free chapter_internal_number value for new chapter insert (chapter can be deleted and it’s chapter_internal_number value should be reused). How to find first chapter_internal_n…
SQL count number of records in one set of data compared to another and present as a percentage
I would like to count the number of unique records not matching on 2 key variables from Data B compared to Data A and present the result as a percentage of the total unique records in Data B. Data A: …
Convert CHAR to int in SQL results in error
I’m using Toad Data Point and am having an issue converting a Column. I’m trying to convert a Column called Rep which contains Char(2) into an integer. The table looks like this: Row_ID Rep 1 …
how to delete first occurrence of each group in sas table?
I have data as follows: ID,date 1,27-08-2020 1,28-08-2020 1,30-08-2020 2,05-08-2020 3,06-08-2020 3,10-08-2020 I have to delete first occurrence for each ID group. so that data becomes ID,date 1,28-08-…
Task Automation on Toad for Oracle
I need to run more than 100 lines SQL queries ‘execute as script’ at 4 am, how can schedule it on oracle toad .