|
SQL server DBA Training
|
|
1
|
198
|
February 10, 2021
|
|
Finding gaps in a series of time periods
|
|
7
|
358
|
February 10, 2021
|
|
How to structure multiple WHERE criteria?
|
|
5
|
187
|
February 9, 2021
|
|
What does MIN(*) do?
|
|
8
|
261
|
February 9, 2021
|
|
Execution plan - explanation
|
|
2
|
372
|
February 8, 2021
|
|
Sql query showing previous month value HELP
|
|
3
|
226
|
February 7, 2021
|
|
Is it possible to query a SQL server AND a local or sharepoint file?
|
|
3
|
230
|
February 5, 2021
|
|
Pivot query with rolling annual values
|
|
3
|
215
|
February 5, 2021
|
|
Query User Count by Quarter with Pivot
|
|
3
|
286
|
February 5, 2021
|
|
Don't return results for a particular condition
|
|
3
|
225
|
February 5, 2021
|
|
Cleanup of output from select statement
|
|
7
|
283
|
February 5, 2021
|
|
How are these statements processed?
|
|
1
|
247
|
February 4, 2021
|
|
Can I use WHERE Col1 IN (SELECT *something*)?
|
|
1
|
247
|
February 4, 2021
|
|
Joining multiple tables
|
|
1
|
216
|
February 2, 2021
|
|
Collapse rows into one
|
|
6
|
365
|
January 31, 2021
|
|
Can I use IN to a SELECT statement?
|
|
9
|
307
|
January 29, 2021
|
|
Combine two select queries
|
|
6
|
249
|
January 29, 2021
|
|
Merge two select quiries
|
|
10
|
242
|
January 26, 2021
|
|
Merge Data fields from different tables into one view table
|
|
1
|
250
|
January 25, 2021
|
|
Heat map data pivot?
|
|
4
|
249
|
January 23, 2021
|
|
Does [Col1] <> 'VALUE' return NULLs or not?
|
|
5
|
275
|
January 22, 2021
|
|
How to create a stored procedure that requires input?
|
|
8
|
2149
|
January 19, 2021
|
|
Why these two statements do not return the same results?
|
|
9
|
354
|
January 14, 2021
|
|
Is this statement correct?
|
|
12
|
581
|
January 18, 2021
|
|
SQL query to find duplicate and remove by giving some conditions
|
|
3
|
273
|
January 17, 2021
|
|
Create a query to refresh multiple materialized views in serie
|
|
0
|
243
|
January 15, 2021
|
|
What does WHERE 1=1 do?
|
|
3
|
355
|
January 14, 2021
|
|
How to get number of employees in the department and manager per employee
|
|
8
|
339
|
January 14, 2021
|
|
HH:MM Accumulative Time format Conversion from Decimal
|
|
13
|
359
|
January 9, 2021
|
|
Quick question on Date operations
|
|
2
|
238
|
January 8, 2021
|