I’m working on an Access database for assigning tasks to personnel and tracking task status and workload. A single user ID can be assigned to one of many fields associated with a particular task. In this case, the Task table has fields for “TechReviewerID” “DesignerID” “Tec…
AWS Glue always send a ‘select * ….’ to the SQL Server , why and how to change that?
I’ve an aws Glue JDBC connection to a SQL server in a EC2 server. After crwaling the whole schema I created a job to query some table and used the activity monitor to check what is glue sending to the database, and the queries are just a select * into the whole table… The code that does that is be…
Oracle Optimize Query
i’m working with oracle pl/sql and i have a stored procedure with this query, and it is a bit convoluted, but it gets the job done, the thing is it takes like 35 minutes, and the sql developer Autotrace says that is doing a full scan even though the tables have their indexes. So is there any way to impr…
SQL count row where progres not done
Need some help, dont know the keyword of this problem to search online I want to count some progres that isn’t done when progres has step3 then its not counted desired result from that example is 2, im trying to do it alone, and it doesnt work help is needed, Thanks Ahead Answer One method uses count(di…
MySQL Running Total By Group, Time Interval
I would like to take a table of customer orders like this: And create a table calculating a cumulative running total by week, segmenting the weeks by 7 days starting at the earliest date (2020-03-01, 2020-03-08, etc.). Something like: Thanks for the help! Answer You can use aggregation and window functions (t…
proc sql: calculate multiple summary stats based on different conditions in one step
I want to calculate two averages, one over rows before a certain date, and the other after a certain date, using proc SQL in SAS. Currently, I’m doing this in two steps and then merge. Is there a way to do this in one step? Thank you. Answer Using the fact that SAS represents true by 1 and false by
Using CTE to determine a specific Hierarchical ID for Family Members
I’m trying to figure out how to attach an incrementing ID to my resultset while using CTE. My table has data like so: PersonId ParentLinkId Relation Name 1 NULL F John …
Oracle slow join with view
I’m using the following query to find a monetary transaction for a person. SELECT PERSON.NAME, MONETARY_TRANSACTION.DESCRIPTION FROM PERSON LEFT JOIN MONETARY_TRANSACTION ON PERSON.ID = …
Postgres a timestamp column constraint from NOT NULL to NULL
I’m trying to run a migration and make basically a column “modified” which is NOT NULL to be NULL. Like there is no need to have that constraint on it, I’ve run yoyo migrations and have the …
Oracle – Divide a string based on total length of string
I have a non standardized data in one of the column and I need to be splitting the data into 3 parts. there is no specific requirement on length each column should have. It’s just that the entire data …