I have a question, can anyone help me with this? I have two SQL queries, one is query on top of reporting calculation view and the other is a query on the base CV of reported CV. Now, I need to …
DBeaver: How to export a result without running 2 queries
I have a query that takes 3-5 minutes to run, so I’d rather not run the query once to generate the result set, and then a second time to generate the exported .csv file. Is there any way to only run …
VB.NET > How to insert an image with Using statement and retrieve it to be displayed?
This is the code I’m working on it to insert an image into database. I think there is nothing wrong with the first part. However, somehow this code is not functioning as it supposed to (no image …
how to insert into table with preselected values from a minus query?
I get specific values by using a statement like select id from x minus (select id from y) it returns multiple rows which I all need to insert into another table. How do I achieve this? I tried …
JPA distinct inner join with Condition on joined table
I have two tables below: I want to get the college object with list of students of a specific department. The SQL query is below: So far I have tried the below JPA query but it is returning multiple College objects. How to return a single college object with list of students with filtered department? NOTE: I can’t alter the
How to update each row that shares the same id differently in postgresql?
Hope this isn’t too hard to explain. I need to update the first table with addresses from the second So basically I have mytable1 that has the following columns: id (pkey) | super_id | address …
Is it possible to remove duplicates from the result for the data set?
I have two following tables, dim_customers and fact_daily_customer_shipments: dim_customers +————-+———————–+———————+ | customer_id | membership_start_date | …
Split single row into multiple rows based on Date and time in SQL Server
I want to split a single row into multiple rows based on time. below are the example. Expected output is below: Day start from 06:00 AM to next day 06:00 AM. When EndDate time is grated than 06:00 AM then split this date in two rows. first row end date is 2018-08-21 05:59:00.000 and next row start 2018-08-21 06:00:00.000. Answer
How to find string that completely matches total or part of input
I will like to write a query to search a table containing millions of records for a value that totally and best matches the search string or its substring only from the beginning. Performance is of …
SSRS : How to make a data set field appear in the footer?
I have a simple report with a dataset( Patient id, programid, name, address, phone). In my report footer, I am trying to write a condition where the footer value shouldn’t show up for specific program …