|
SQL Developer Database Tips
|
|
2
|
258
|
December 23, 2019
|
|
Does this explain all the joins correctly?
|
|
5
|
501
|
December 20, 2019
|
|
Left join date record
|
|
13
|
689
|
December 20, 2019
|
|
Retrieving a string of Text from XML
|
|
8
|
297
|
December 19, 2019
|
|
Recursive CTE query
|
|
4
|
440
|
December 19, 2019
|
|
Subquery to grab percentage by unique criteria
|
|
9
|
435
|
December 16, 2019
|
|
Left join date
|
|
5
|
398
|
December 15, 2019
|
|
Need help writing SQL query to find value from a table based on two specific values
|
|
1
|
281
|
December 14, 2019
|
|
Cast as Text or Int based on data
|
|
13
|
387
|
December 12, 2019
|
|
Problems with the From Clause
|
|
5
|
269
|
December 11, 2019
|
|
Max records from multiple columns with a conditions
|
|
2
|
300
|
December 10, 2019
|
|
Run CMD in sql job
|
|
7
|
5820
|
December 10, 2019
|
|
Sql query help
|
|
18
|
393
|
December 6, 2019
|
|
Trying to create a linked server to an advantage database through management studio
|
|
1
|
523
|
December 5, 2019
|
|
Random number in results searching for >= and <= numbers?
|
|
7
|
449
|
December 2, 2019
|
|
Convert SQL query to SQLite
|
|
2
|
542
|
December 2, 2019
|
|
Conversion failed when converting the nvarchar value
|
|
5
|
12120
|
December 1, 2019
|
|
Subquery Count Not Grouping
|
|
3
|
296
|
November 29, 2019
|
|
Selecting "amount paid" based on most recent "date paid"
|
|
5
|
333
|
November 28, 2019
|
|
Mapping problem in nested view
|
|
5
|
318
|
November 26, 2019
|
|
App timeouts during SQL backups
|
|
1
|
327
|
November 26, 2019
|
|
Getting 1 Row for same ID , diff values
|
|
3
|
316
|
November 24, 2019
|
|
Get the most recent record using Max as a condition
|
|
7
|
396
|
November 24, 2019
|
|
Combining multiple rows data into single start and end date
|
|
6
|
419
|
November 24, 2019
|
|
How to backup the xmldata table in sql server 2016
|
|
11
|
372
|
November 23, 2019
|
|
How can I make database name as values to a variable?
|
|
4
|
1038
|
November 22, 2019
|
|
Union Query for Summary Total
|
|
4
|
284
|
November 21, 2019
|
|
Determine summation data
|
|
4
|
285
|
November 20, 2019
|
|
An invalid floating point operation occurred
|
|
1
|
3827
|
November 19, 2019
|
|
, determine the number of jobs posted. If a company doesn't have posted jobs, show 0 for that company
|
|
2
|
308
|
November 20, 2019
|