Converting Access to TSQL
|
|
1
|
160
|
July 12, 2022
|
How to query with date/time with separate column in sql
|
|
6
|
1003
|
July 12, 2022
|
SSIS datatype conversion string to float
|
|
0
|
780
|
July 12, 2022
|
Database migration from Sybase ASE to Azure SQL managed instance
|
|
0
|
377
|
July 12, 2022
|
How to get quarterly months from this SQL code that is doing previous months?
|
|
1
|
161
|
July 10, 2022
|
Simplify script
|
|
4
|
180
|
July 11, 2022
|
Connection to cloud based SQL Server database using VBA
|
|
0
|
167
|
July 11, 2022
|
Combining tables with overlapping date ranges
|
|
2
|
204
|
July 10, 2022
|
Count is not working
|
|
3
|
139
|
July 9, 2022
|
Applying WHERE before JOIN
|
|
5
|
200
|
July 8, 2022
|
Can multiple criteria be combined without nesting SELECT?
|
|
1
|
147
|
July 7, 2022
|
Restore in SQL2019 a backup created in SQL2000
|
|
1
|
241
|
July 7, 2022
|
How to fetch the set of data from one or another table in sql
|
|
1
|
150
|
July 7, 2022
|
Separate different types of values from the same column into separate columns
|
|
1
|
156
|
July 7, 2022
|
SSIS sql query error
|
|
4
|
2777
|
July 7, 2022
|
Sitecore - Filter out Sitecore Errors
|
|
0
|
189
|
July 7, 2022
|
Azure Function with TDS(Tabular Data Stream) and MFA enabled Authentication
|
|
0
|
201
|
July 7, 2022
|
Different execution plan on different time with same query
|
|
4
|
1025
|
July 7, 2022
|
Transform table by pivoting/transposing
|
|
6
|
192
|
July 6, 2022
|
IF statement under WHERE
|
|
2
|
132
|
July 6, 2022
|
What does this REPLACE function do?
|
|
1
|
153
|
July 5, 2022
|
How to get table name from another table in select query
|
|
5
|
3470
|
July 5, 2022
|
How to Unsplit Azure Data Studio?
|
|
1
|
931
|
July 5, 2022
|
Migrating one BI tool to another plus DWH from on-prem to cloud. Transitional roadmap advice
|
|
2
|
546
|
July 4, 2022
|
How to extract specific row value into a new column based on shared reference number?
|
|
0
|
229
|
July 4, 2022
|
MS SQL working days - the average number of cases per 1 working day
|
|
5
|
222
|
July 4, 2022
|
Selecting Departments With More Than 10,000 Female Employees
|
|
7
|
225
|
July 3, 2022
|
Obtaining Top 5 Employees Having Highest Average Salaries and Maximum Salary < 100000
|
|
7
|
170
|
July 2, 2022
|
Finding the Average Salaries for Each Employee's Gender
|
|
3
|
159
|
July 2, 2022
|
List only distinct results
|
|
2
|
153
|
July 2, 2022
|