SUMIFS (Excel) to SQL
|
|
4
|
2641
|
February 10, 2023
|
Comparing 2 table's values to see how many of them are common
|
|
3
|
281
|
February 9, 2023
|
SQL - percentage from total
|
|
7
|
540
|
January 22, 2023
|
Are there any areas that need improvement for this query
|
|
13
|
283
|
February 8, 2023
|
I am trying to pull the most recent completed job for my employees
|
|
1
|
222
|
February 7, 2023
|
Sorting by date into groups
|
|
3
|
146
|
February 7, 2023
|
SQL Retrieve ALL if match a condition
|
|
12
|
137
|
February 7, 2023
|
Join to tables link field between 2 values
|
|
1
|
122
|
February 6, 2023
|
Figuring out how to get optimized storage positions in vertical Warehouse with T-SQL
|
|
0
|
117
|
February 5, 2023
|
Return a MAX(DATE_START) from a child table and a parent table
|
|
2
|
177
|
February 3, 2023
|
Getting records randomly one by one based on a certain criteria
|
|
10
|
149
|
February 2, 2023
|
How to create a rolling date search between two months
|
|
2
|
1590
|
January 31, 2023
|
How to make a backup (.bak) file with desired physical / logical names
|
|
4
|
154
|
January 31, 2023
|
I want to take a database backup automatically and to zip the database automatically
|
|
35
|
22603
|
January 31, 2023
|
Sort alphanumeric values
|
|
10
|
480
|
January 30, 2023
|
Sub select based on the value of the sub select
|
|
3
|
248
|
January 30, 2023
|
How to put multiple printed rows in one line in sql?
|
|
3
|
1098
|
January 30, 2023
|
Select Random Rows
|
|
7
|
378
|
January 29, 2023
|
How would you compare an excel with data in the database table?
|
|
19
|
252
|
January 29, 2023
|
Quick SQL Question
|
|
1
|
137
|
January 27, 2023
|
Calculate sections of time
|
|
3
|
193
|
January 27, 2023
|
Concat multiple columns in alphabetic order
|
|
3
|
1084
|
January 27, 2023
|
Finding Integer in a string located in another table
|
|
8
|
237
|
January 26, 2023
|
SQL queries, select records with specific datatime occurrences (3 per week, 3 days in a row )
|
|
6
|
213
|
January 26, 2023
|
Assign user name to task on Round Robin approach
|
|
3
|
185
|
January 26, 2023
|
Total sur sql query
|
|
0
|
159
|
January 26, 2023
|
How to encrypt column in sql server 2008r2
|
|
6
|
146
|
January 24, 2023
|
First entry is break out second entry is break in
|
|
5
|
138
|
January 23, 2023
|
TSQL - Assign same value to every line where condition is met for one line using case logic
|
|
2
|
140
|
January 23, 2023
|
Creating a back up with date attached to it
|
|
6
|
145
|
January 20, 2023
|