This seems like a reasonably simple problem but I cannot figure out how to change a numerical value of a month into the months actual name after the sales count is grouped by the month. Basically I …
Tag: sql
SQL: Retrieve Distinct for different columns
I have the following scenario: In a SQL-Table I have the following columns: |—————————————-|————————————-| | Col 1 |…
How to select a record if it is equal to any record of a column from a different table?
I have a table with adresses, which were separated by spaces into different columns. Since the name of the streets can be made up from 1-2-3 etc. parts, the street suffices are placed in different …
Conditionally remove rows from ms access query (SQL)
I would like to remove rows (about 10000) from a report in ms access. I am comparing two sets of two column in a table. When I run the query I would like it to remove the rows where column 1 and 3 …
SQL Server: table join based on record-dependent values
There’s a general type of query I’m trying to perform, and I’m not sure how to express it in words so that I can find a discussion of best practices and examples for executing it. Here’s an example …
SQL Server query to find where all preceding numbers are not included per each ID for a specific column
I am having a hard time trying to explain this succinctly but basically I need to query Table A for each ID number and find where in the positions column there are missing sequential numbers for each …
Show results from different queries in 1 overview in MS-ACCESS
I have different relational tables and I perform different queries on these tables to get some results. This is 1 example of a query called PBF SELECT I90DIA26.[Unidad_de_Programacion], SUM(…
How to get average value using LEFT JOIN in LINQ and Lambda
I want to display each book average rating with its publisher using LINQ and Lambda. Here’s my book list private List Books = new List(){ new Book { Id: 1, Name: Book A, …
Query to generate map table to matrix table
I have 1 map table Group Task —– —– Admin Add Admin Edit Admin Delete Admin View User View I need to generate it in a matrix table like Task Admin User —— —— —— Add …
VBA Runtime Error when connection to SQL Database
I’m trying to connect to a SQL Server from multiple PCs in the same domain. When using the following code: conn.Open returns the error: Error on login for the user ‘XXXX’ Answer The issue is because you are using a named user with Integrated Security. These two modes are incompatible. Try re…