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 …
Tag: sql
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)….
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
Showing multi row in one row
I am developing a page where I have to show all the jobs of an employee with a work number and the total of each type of hours in each work I can display it, but, my problem is when the employer …
Is there a way to import all databases into one database with Mysqldump?
I want to gather automatically all my databases into one with Mysqldump, is there a way to do it ? For example what I want is to move all the tables from DB1, DB2 and DB3 into DB4 (DB4 can already …
PostgreSQL DROP VIEW IF EXISTS
In PostgreSQL when I run the command DROP VIEW IF EXISTS view_name; I get the response: View IF dropped. Can anyone explain what this means? why the word ‘IF’ instead of a response like: View …
Gaps And Islands: Splitting Islands Based On External Table
My scenario started off similar to a Island and Gaps problem, where I needed to find consecutive days of work. My current SQL query answers “ProductA was produced at LocationA from DateA through DateB,…
For JDBC prepared statements, how are the position of variables determined when an actual value is supplied in the SQL statement
If I have the following code, with one value supplied in the SQL statement, what would be the value of the position for GROUP? Is it 2 or 3? In other words, is the supplied value counted when …
How to design entity tables for entities with multiple names
I want to create a table structure to store customers and I am facing a challenge: for each customer I can have multiple names, one being the primary one and the others being the alternative names. …
Select all subscriptions whose users don’t have any other active subscription
I am writing a subscription cleanup query that should select all canceled subscriptions, whose users don’t have any other active subscription (the application allows multiple subscriptions per user). …