|
Create a separate WINDOW clause and then reference it in each OVER
|
|
2
|
133
|
May 17, 2022
|
|
Why select count(distinct *) does not work?
|
|
5
|
2869
|
May 16, 2022
|
|
Sql connection
|
|
1
|
292
|
May 14, 2022
|
|
How to capture Next 72hrs data query
|
|
0
|
165
|
May 13, 2022
|
|
SQL request
|
|
3
|
147
|
May 13, 2022
|
|
Sql server table function
|
|
2
|
183
|
May 13, 2022
|
|
Two options on Where Clause
|
|
2
|
148
|
May 13, 2022
|
|
I would like an explanation of a SQL script
|
|
6
|
183
|
May 12, 2022
|
|
Select single row from double rows with same id but different event type
|
|
2
|
295
|
May 11, 2022
|
|
Updating SQL tables values with Excel
|
|
1
|
174
|
May 9, 2022
|
|
Sql that shows info from two tables
|
|
6
|
234
|
May 8, 2022
|
|
Display 1 record instead of 2 record
|
|
8
|
225
|
May 8, 2022
|
|
SSRS report email send out
|
|
6
|
1597
|
May 5, 2022
|
|
Stg to patg in ssis
|
|
3
|
192
|
May 5, 2022
|
|
Sql workbench
|
|
0
|
150
|
May 4, 2022
|
|
Prepare list of Servers with SPK info, near to warranty expiry
|
|
1
|
155
|
May 4, 2022
|
|
Totals in Pivot table
|
|
0
|
141
|
May 3, 2022
|
|
Help w/self join?
|
|
6
|
184
|
May 3, 2022
|
|
Conditions within left join
|
|
2
|
242
|
May 2, 2022
|
|
SQL automated backup
|
|
3
|
143
|
May 2, 2022
|
|
Two Records into 1 record from 2 tables
|
|
2
|
203
|
April 29, 2022
|
|
Different Currency rate in currency table and invoice transactions
|
|
2
|
169
|
April 29, 2022
|
|
Cyclic work of triggers
|
|
4
|
390
|
April 27, 2022
|
|
Updating Current table with next day's data while keeping the previous data
|
|
6
|
249
|
April 25, 2022
|
|
CSV Resultset for IN clause
|
|
3
|
180
|
April 22, 2022
|
|
Help Grouping/Collapsing DataSet
|
|
8
|
251
|
April 18, 2022
|
|
SQL 2014 v12 - Query - Find CPU Age - How old
|
|
8
|
238
|
April 15, 2022
|
|
Read metadata for data type or allows null etc
|
|
8
|
190
|
April 14, 2022
|
|
PIVOT Function for Text
|
|
5
|
1497
|
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
|
154
|
April 13, 2022
|