|
Get only last row in each day's multiple entries
|
|
5
|
377
|
October 6, 2022
|
|
Query a dataset that includes a table that is not in the database using Visual Basic
|
|
0
|
159
|
October 3, 2022
|
|
Write the SQL code needed to answer the question: What are the brands purchased by the customers?
|
|
2
|
281
|
September 29, 2022
|
|
ORDER BY in CTE
|
|
10
|
7000
|
September 29, 2022
|
|
Spliiting complex string column to multiple columns
|
|
1
|
227
|
September 27, 2022
|
|
Indexing for Compute Column concatenate columns
|
|
2
|
133
|
September 26, 2022
|
|
Duration column totaling issues
|
|
1
|
154
|
September 25, 2022
|
|
Filtering out records in first table that join to multiple records in second table
|
|
5
|
194
|
September 23, 2022
|
|
Stock Database select question
|
|
2
|
188
|
September 21, 2022
|
|
Displaying a table of sql records
|
|
0
|
166
|
September 21, 2022
|
|
How to find what you need to on a server with a multitude of databases (and virtually no documentation)
|
|
13
|
290
|
September 20, 2022
|
|
SQL Request Total
|
|
2
|
141
|
September 20, 2022
|
|
Fuzzy matching
|
|
5
|
290
|
September 19, 2022
|
|
Quickly inserting hardcoded table
|
|
11
|
2156
|
September 19, 2022
|
|
Can we see all users and permissions?
|
|
0
|
130
|
September 19, 2022
|
|
Relationship web
|
|
6
|
232
|
September 17, 2022
|
|
List all permissions assigned to user defined SERVER roles
|
|
4
|
549
|
September 15, 2022
|
|
SQL SERVER Triggers + MS-ACCESS FORMS
|
|
0
|
228
|
September 14, 2022
|
|
New login unable to sign-on to SSMS
|
|
0
|
204
|
September 13, 2022
|
|
OData source connection to SharePoint with legacy authentication allowed
|
|
0
|
405
|
September 12, 2022
|
|
Operator Precedence in SQL: And and Or
|
|
3
|
252
|
September 12, 2022
|
|
Tablename not recognized
|
|
10
|
489
|
September 8, 2022
|
|
SQL Average Daily Bookings
|
|
5
|
283
|
September 8, 2022
|
|
Removal(?) of a feature with newer releases of a Nuget package
|
|
0
|
132
|
September 7, 2022
|
|
Generate permutations and filter
|
|
2
|
221
|
September 7, 2022
|
|
Select TOTAL(last year), TOTAL(year to date), TOTAL (last month)
|
|
3
|
229
|
September 6, 2022
|
|
Select all rows where table1.column1 = table2.column1 where at least one value table2.column2 = 1
|
|
2
|
155
|
September 5, 2022
|
|
Last time index was re-org or rebuilt?
|
|
1
|
126
|
September 5, 2022
|
|
MS SQL Add DB sizes into a "total" variable and add to end of size column results
|
|
0
|
147
|
September 4, 2022
|
|
Running import job into application results in sql error
|
|
4
|
382
|
September 2, 2022
|