|
Using aliases in Common Table Expression (CTE)
|
|
14
|
5006
|
June 30, 2021
|
|
Backup/Restore rights for a SQL user
|
|
1
|
590
|
June 19, 2015
|
|
Equivalent of PCD.Value for Quantities?
|
|
1
|
731
|
May 29, 2015
|
|
Syntax for pulling the max date, and then the previous date which has to be at least 75 days from the max date?
|
|
4
|
490
|
March 30, 2018
|
|
Installing SP1 for 2014
|
|
1
|
684
|
September 21, 2015
|
|
SSIS dedicated Server Hardware
|
|
13
|
1271
|
May 21, 2020
|
|
Can I use case statements in my update query
|
|
1
|
398
|
February 17, 2016
|
|
Converting varchar divide to a percentage
|
|
3
|
1492
|
March 11, 2021
|
|
Insert only not exists data
|
|
5
|
295
|
February 29, 2020
|
|
Create Auto Insert Script - 500k records to load data into sql server
|
|
2
|
1006
|
June 22, 2017
|
|
To calculate age and put age category
|
|
4
|
1121
|
October 5, 2016
|
|
Convert string to datetime OPENXML WITH
|
|
1
|
994
|
March 10, 2016
|
|
How to read data based on the Row Number
|
|
2
|
235
|
November 17, 2020
|
|
Time Clock Management
|
|
11
|
910
|
March 25, 2019
|
|
Alternative for utl_file package in sql server 2008 r2
|
|
2
|
1461
|
July 28, 2015
|
|
ERD diagram of a read only database with no access to tools
|
|
1
|
1100
|
May 19, 2023
|
|
Group results by item showing most recent date and extra info
|
|
2
|
901
|
April 17, 2016
|
|
AlwaysON listener connectivity issue
|
|
4
|
1249
|
December 29, 2019
|
|
Transpose rows to column
|
|
2
|
246
|
May 2, 2018
|
|
How to stop backup process
|
|
2
|
8244
|
November 6, 2015
|
|
Spam Cleanup
|
|
1
|
425
|
May 8, 2005
|
|
Get FileTable Share Folder and subfolders from server and database
|
|
1
|
756
|
July 29, 2016
|
|
CSV files with 12 columns, the last 3 columns have all NULL value
|
|
1
|
774
|
November 24, 2016
|
|
How to replace where exists with inner join?
|
|
6
|
4448
|
September 16, 2021
|
|
How to rank and count the data in sql
|
|
2
|
658
|
October 1, 2017
|
|
Ssrs 2012 displayed different data on detail lines based upon a user's selection
|
|
0
|
409
|
February 8, 2018
|
|
Get from XML all ObjectNames LIKE 'MF%' OR 'MC%'
|
|
2
|
732
|
February 16, 2017
|
|
Showing results of one column into two columns
|
|
7
|
412
|
August 12, 2020
|
|
SQL Query to Pull unique row from table
|
|
2
|
608
|
April 22, 2017
|
|
Finding a date range for quarter based on yyyymm input
|
|
3
|
1456
|
February 9, 2017
|