My goal To calculate the sum of components sold as part of their parent assemblies. I’m sure this must be a common use case, but I haven’t yet found documentation that leads to the result I’m looking for. Background I’m running Postgres 11 on CentOS 7. I have some tables like as follows: And a view like so, which is
Tag: business-intelligence
Is there a way to filter rows in BigQuery by the contents of an array?
I have data in a BigQuery table that looks like this: My question is, how can I find all rows where “key” = “a”, “value” = 1, but also “key” = “b” and “value” = 3? I’ve tried various forms of using UNNEST but I haven’t been able to get it right. The CROSS JOIN leaves me with one row
SQL Query Challenge. Divide by Subquery returning ‘Subquery returned more than 1 value.’ error
I have the following table in which I have two sales orders and each sales order has a different number of transactions. SaleOrder Transaction Amount Tax Delivery Charge TotalTax (Including Tax of Delivery Charge) S1 T1 12 0 3 5.5 (This also includes Tax in Column 4) S1 T2 27 4 3 5.5 S2 T1 15 2.5 5 6 S2
How do I make an aggregate on an integer with a grouped column, for which I only want some included?
I have a table prices holding all prices that some products have had: The first entity for a product_id is it’s initial sales price. If the product is then reduced, a new entity will be added. I would like to find the mean and total price change per day across all products. This is some sample data: The expected result
Data flow task executing successfully but not writing any rows to Excel file
I am working on SSIS package that is fetching data from SQL server and inserting into Excel file… in Data Flow Task i’ve used OLE Db source and Excel destination. After configuring OLE Db source i can preview the resulting row and even data flow task executing successfully without giving any error.. but not inserting any row.. Answer Well fortunately