Normalized data giving you problems? Learn how to use the SQL subselect statement and handle your database like a pro! Do you ever find yourself juggling queries to get the information you need?

Description When the option "Always use subselect for filters" is active and a table field is aliased in a query, attempting to sort the data grid results by that column creates invalid sql by using ...

One of the many interesting things that caught my eye in the new SSAS Tabular Performance Tuning white paper is actually about new functionality in the SSAS 2012 Multidimensional and nothing to do ...

astefan added >bug :Query Languages/SQL SQL querying v8.0.0 v7.6.3 v7.8.0 v7.7.1 labels Apr 29, 2020 astefan requested review from costin, bpintea and matriv April 29, 2020 18:03 Collaborator ...

invoice_noinvoice_dateinvoice_amountpayment_amount*payment_date** means that more than one payment can exist against the invoice.All the info is in the same table, and the relationship of the invoice ...