|
SQL Subquery need to rewrite to optimise
|
|
4
|
250
|
November 7, 2022
|
|
Not sure how to pivot this data?
|
|
1
|
216
|
November 4, 2022
|
|
HY000:[DataDirect][OpenEdge JDBC Driver][OpenEdge] Invalid date string (7497)
|
|
2
|
650
|
November 4, 2022
|
|
Subquery Help
|
|
0
|
192
|
November 4, 2022
|
|
Ten thousand places
|
|
1
|
179
|
November 4, 2022
|
|
Do I need self joins, cte?
|
|
3
|
254
|
November 4, 2022
|
|
How to Prevent Duplicate values
|
|
16
|
353
|
November 2, 2022
|
|
Need to parse a column but with 2 possible scenarios
|
|
1
|
161
|
October 31, 2022
|
|
Union tables and fill null with last not null
|
|
16
|
2856
|
November 1, 2022
|
|
Find duplicate values in one column and return data from different colums/tables
|
|
4
|
540
|
October 31, 2022
|
|
Is it possible to run a query separated by empty lines in ADS without having to highlight it?
|
|
2
|
192
|
October 31, 2022
|
|
How to specify GROUB BY in a neat and dynamic way?
|
|
2
|
300
|
October 31, 2022
|
|
CASE Statement Help
|
|
3
|
210
|
October 28, 2022
|
|
Column Seperate
|
|
11
|
231
|
October 27, 2022
|
|
If there is a value in the column then to say so
|
|
2
|
155
|
October 26, 2022
|
|
Dax command to get first data
|
|
0
|
211
|
October 25, 2022
|
|
Where clause to query records from current day
|
|
1
|
217
|
October 25, 2022
|
|
DB solutions available?
|
|
4
|
200
|
October 24, 2022
|
|
Explain Plan using Set statistics IO, Time On
|
|
0
|
172
|
October 23, 2022
|
|
Need help writing maximum life insurance expression
|
|
1
|
159
|
October 21, 2022
|
|
CASE statement inside COUNT
|
|
5
|
298
|
October 21, 2022
|
|
Issue Using a Case Statement in a Where Clause
|
|
5
|
212
|
October 20, 2022
|
|
Data file and Log File size in Sql server Always ON
|
|
19
|
5075
|
October 19, 2022
|
|
SQL instance unreachable - how to troubleshoot
|
|
4
|
585
|
October 19, 2022
|
|
SP stopped working after build update
|
|
13
|
275
|
October 17, 2022
|
|
How do one know data types of cells in columns in SQL
|
|
2
|
147
|
October 16, 2022
|
|
CASE statement to add/subratct x from month then aggregate at year level
|
|
2
|
257
|
October 14, 2022
|
|
Case with froup by-multiple lines
|
|
1
|
137
|
October 13, 2022
|
|
Add or Subtract from Count for any given month range
|
|
0
|
145
|
October 13, 2022
|
|
Compare 2 big dataset for all rows and columns
|
|
6
|
2038
|
October 12, 2022
|