I’m facing a problem with the data I’ve because of duplicate accounts, and I need to find all the duplicate accounts. For example Main_account_number: XXXXXX | Duplicate_account_number: 00000XXXXXX. …
How to fix “Ambiguous column name” in a h2 db
I have a h2 database setup. In my tables, that are being used by the sql query, there are no ambiguous column names, but the query always fails due to that. db setup I’ve tried to minimise the sql …
Selecting an attribute that has max value for another attribute
**** Edit: How do I also consider the case where there is more than one property with the highest value? I’m trying to write an outer query that takes the propertyname with the highest value from an …
How to relationalize, join and aggregate multiple files from S3
I have a bucket in S3, containing hundreds of folders, each contains files with the same structure, which are csv representation of relational db tables. The different folders differ by content of the …
SQL set value for case depending on whether or not value exists
I am looking up addresses from one table from a user based on the user’s email from another table, then take the resulting list of addresses and check if the address has an attribute that is stored on …
Alias an entire table’s fields
Let’s say I am querying/joining two tables, each with certain identical field names: SELECT * FROM sales1 s1 JOIN sales2 s2 USING (id) Is it possible to prefix the columns for each table with the …
Issue with ODBC Object connection – Open limitation to 65k rows
New to programming, SQL and VBA. I frequently work with decent size data tables and thought it would be helpful to add SQL query execution capability to apply to an existing excel table. Research led …
choose a few id from db C#
I have a database and excel file And I want to export strings to excel How to export strings with 1 id I know The code you can see below _Hours = Rep.Where(o => o.Projects.ProjectGroupID == 4)….
Query over multiple tables including SUM
I am looking for the correct syntax I can set up different queries but I am looking for one query Tables: T1 Country Metal Date Pnum Austria Gold 20-Dec-18 P31182 Austria Gold …
SSIS data conversion issue of decimal
I have a dtsx package running in SSIS on our SQL server (2016 SP2 CU6), its a lightweight task of importing an Excel (xlsx) worksheet into a table in SQL as-is, no transformations needed at this stage, there is an agent job that does a lot more around it but I can see the fault is occurring in just this