|
SSIS Packages
|
|
0
|
82
|
September 15, 2021
|
|
Merge Replication across different network
|
|
1
|
69
|
September 15, 2021
|
|
Correlated subquery advice?
|
|
2
|
84
|
September 15, 2021
|
|
Re-Structure data for reporting
|
|
4
|
93
|
September 15, 2021
|
|
Getting the list of all customers not having sign documents
|
|
3
|
93
|
September 15, 2021
|
|
Min and Max Group by Position Segment
|
|
12
|
136
|
September 14, 2021
|
|
Deals, revenu and margin by month, help
|
|
15
|
89
|
September 14, 2021
|
|
SQL Query to populate the null records with upper actual value
|
|
2
|
70
|
September 13, 2021
|
|
Dynamic sql if exists drop andcrete funcation or procedures
|
|
5
|
92
|
September 12, 2021
|
|
Always backup database with encryption
|
|
1
|
74
|
September 12, 2021
|
|
How to create a new column and group by that column in a selection?
|
|
11
|
139
|
September 12, 2021
|
|
Adding new columns to tables and combining the tables
|
|
8
|
127
|
September 11, 2021
|
|
SQL Performance Management without using SQL Profiler
|
|
4
|
227
|
September 10, 2021
|
|
How to compute the monthly headcount by taking account the entries in the month and the exits in the month
|
|
1
|
79
|
September 10, 2021
|
|
Date Query Issue
|
|
5
|
105
|
September 10, 2021
|
|
Calculate retention with SQL
|
|
3
|
91
|
September 10, 2021
|
|
Find the manager of a manager in the same table
|
|
4
|
104
|
September 9, 2021
|
|
Count all employee under each manager
|
|
2
|
104
|
September 9, 2021
|
|
Match by a date
|
|
7
|
108
|
September 9, 2021
|
|
Using varchar or varbin for long hex strings
|
|
4
|
98
|
September 8, 2021
|
|
Select top 10 Rows AND Table Name
|
|
3
|
75
|
September 8, 2021
|
|
String_agg()
|
|
4
|
105
|
September 8, 2021
|
|
Database Has Older Compatibility Level
|
|
2
|
77
|
September 8, 2021
|
|
Verifying Backups
|
|
5
|
114
|
September 7, 2021
|
|
Linking two table based on composite key to show all related record and 0 for unrelated records
|
|
5
|
91
|
September 7, 2021
|
|
Query help
|
|
2
|
75
|
September 7, 2021
|
|
Can High Availability Lag affect the Primary Server?
|
|
14
|
145
|
September 5, 2021
|
|
SSIS http connection 401 unauthorized
|
|
2
|
124
|
September 4, 2021
|
|
TSQL WITH clause slow query
|
|
4
|
153
|
September 4, 2021
|
|
How to pass list of table names to a stored procedure
|
|
39
|
342
|
September 3, 2021
|
