|
Create a separate WINDOW clause and then reference it in each OVER
|
|
2
|
137
|
May 17, 2022
|
|
Why select count(distinct *) does not work?
|
|
5
|
3278
|
May 16, 2022
|
|
Sql connection
|
|
1
|
316
|
May 14, 2022
|
|
How to capture Next 72hrs data query
|
|
0
|
166
|
May 13, 2022
|
|
SQL request
|
|
3
|
151
|
May 13, 2022
|
|
Sql server table function
|
|
2
|
193
|
May 13, 2022
|
|
Two options on Where Clause
|
|
2
|
152
|
May 13, 2022
|
|
I would like an explanation of a SQL script
|
|
6
|
208
|
May 12, 2022
|
|
Select single row from double rows with same id but different event type
|
|
2
|
322
|
May 11, 2022
|
|
Updating SQL tables values with Excel
|
|
1
|
178
|
May 9, 2022
|
|
Sql that shows info from two tables
|
|
6
|
247
|
May 8, 2022
|
|
Display 1 record instead of 2 record
|
|
8
|
235
|
May 8, 2022
|
|
SSRS report email send out
|
|
6
|
1654
|
May 5, 2022
|
|
Stg to patg in ssis
|
|
3
|
197
|
May 5, 2022
|
|
Sql workbench
|
|
0
|
154
|
May 4, 2022
|
|
Prepare list of Servers with SPK info, near to warranty expiry
|
|
1
|
160
|
May 4, 2022
|
|
Totals in Pivot table
|
|
0
|
147
|
May 3, 2022
|
|
Help w/self join?
|
|
6
|
200
|
May 3, 2022
|
|
Conditions within left join
|
|
2
|
245
|
May 2, 2022
|
|
SQL automated backup
|
|
3
|
150
|
May 2, 2022
|
|
Two Records into 1 record from 2 tables
|
|
2
|
208
|
April 29, 2022
|
|
Different Currency rate in currency table and invoice transactions
|
|
2
|
190
|
April 29, 2022
|
|
Cyclic work of triggers
|
|
4
|
412
|
April 27, 2022
|
|
Updating Current table with next day's data while keeping the previous data
|
|
6
|
262
|
April 25, 2022
|
|
CSV Resultset for IN clause
|
|
3
|
201
|
April 22, 2022
|
|
Help Grouping/Collapsing DataSet
|
|
8
|
260
|
April 18, 2022
|
|
SQL 2014 v12 - Query - Find CPU Age - How old
|
|
8
|
261
|
April 15, 2022
|
|
Read metadata for data type or allows null etc
|
|
8
|
204
|
April 14, 2022
|
|
PIVOT Function for Text
|
|
5
|
1862
|
April 14, 2022
|
|
I need help creating an 'update' to aggregate or concatenate several records from a table into a field in another table
|
|
2
|
156
|
April 13, 2022
|