Suppose, I need to delete or update some id informations from my database, which would be the best way to do it? Should I first find out that if that id exists or not? Or should I update the data then …
Create chart where the columns of the data set are the categories – Report Builder 3.0
I have a very simple chart that I am wanting to add but I can’t for the life of me figure it out. The chart is referencing a dataset that returns data like this. It is calculating the sum of each …
How to group this table properly?
Here’s my dataset with expected out. But I am having issues doing it. Also, I attached the query I created and the output is not correct. could you please point me to where my mistake is? DROP TABLE …
How do I display my query results as part of a string?
My database is for a school project and handles various jobs/contracts which are ran by consultants. Apologies if the context is vague, we haven’t really been given much either. My current code does …
MS Access SQL for UNION from 3 similar tables INSERT INTO a single field in a 4th table?
Aim: Select all distinct values from three different columns, each located in a different table: [QueryA].Att1, [QueryB].Att2, [QueryC].[Att C]. Return all selected values in a single column in a 4th …
SQL Server – Remove some numbers in a string contains numbers
I have a column contains string with numbers formatted as comma delimiter. I want to write an update query to update those numbers in the column based on the numbers to be removed that provided, but I …
How can I count unique clicks across jobs for each category
I store link performance attributed to different categories in a sent table like this… CREATE TABLE sent ( customer_id INT, jobId INT, category VARCHAR(100), timestamp DATETIME DEFAULT …
How to left join more than 3 tables [closed]
I’m struggling as a junior to create a view based on 5 tables: Country, Business, SubBusiness, Role and Type CREATE VIEW my_view AS SELECT DISTINCT `a`.`country`, `b`.`business`, `c`.`sub_business`, `…
SQL window function with date filter
Looking to do a LAG/LAST_VALUE/MAGIC window function on a table which somehow needs to include a date filter (as in how far back it should go). I’m trying to get the value as of 7 days ago onto every …
Another instance of Derby may have already booted the database
I’m connecting to a Derby DB through the command line. After connecting, by mistake got out from IJ in a unproper way. Now when I try to connect again this message is shown: I think this is happening …