In my web application, I have 3 tables: TAB A: Recipes (id, name) TAB B: Recipes_Ingredients(id, fk_recipe,fk_ingredient, quantity) Bridge table TAB C: Ingredie
I have a table having a JSON datatype column which contains JSON array consisting of IDs for another table. I want to return matching rows from that other table
I would like to create the dynamic partition in one of my SSAS tabular model. To do so I found one approach with SSIS package which involves the "Analysis Servi
I want to merge two tables with different columns mysql. For e.g. Table 1 : ------------------------------------------------------------- item_id title sl
Say that I have an analysis with the columns Month, Difficulty, and Score. The report has a filter Month = August, but the column Difficulty changes within the
I have a code not total like normal distribution. How can I change it from Mysql to SQL Server? select latency where pow(e(), - pow((ln(latency) - 8.223) ,2)/2
I would appreciate your help very much as I’m still at beginner level in SQL. Thank you :) I have tables representing counties, vendors and their respecti
When I execute the code below I get Error Code: 29. File '/Applications/XAMPP/xamppfiles/htdocs/Gefle442/csv/places.csv' not found (Errcode: 13 "Permission deni
I'm hurting my head again this : On postgresql, I would like to get the local time for a given timezone. So, at 15:45 GMT, I want 16:45 for +01:00, but I can't
I have problems with SSIS process(acctually the same problem occurs for two different processes). So, we are doing some ETL work using SSIS. We have Business In
I have two SQL tables. Each has an ID with other columns and a Date. Is there a way that I can get the result from these two tables in one query sorted by the
In general we are supposed to pass integer values to our stored procedures and to do so we usually do it with this method command.Parameters.AddWithValue("@para
I am trying to find the count of tables present in CDC schema, I tried with information_schema but the information_schema is empty for me.
I have 2 tables: table "person" with columns: person_id, person_name table "pet" with columns: pet_id, owner_id, pet_name person data: 1, 'John' 2, 'Jill' 3,
I am writing a data-mining program, which bulk inserts user data. The current SQL is just a plain bulk insert: insert into USERS( id, username, profile_pi
I don't know how to pass User Defined Variables (from JMeter .jmx Script) on jenkins-taurus.yml (Taurus BlazeMeter configuration file). It keeps pushing the fix
I'm currently working on a .NET application and want to make it as modular as possible. I've already created a basic SELECT procedure, which returns data by che
I'm trying to convert an sql query into tuple relational calculus, but there is a NOT EXIST that causes me to be stuck. SQL query: SELECT num FROM a a1, b b1
I am counting 7-day active users using T-SQL. I used the following code: SELECT *, COUNT(DISTINCT [UserID]) OVER ( PARTITION BY [HospitalID],
Update on 2022-05-15 After running vacuum analyze, the query plans are below. For A query Nested Loop Left Join (cost=45913.11..496597.16 rows=10 width=128) (a