|
How can I get below answer based on given tables with data? I have done some steps but not able to get the answer
|
|
4
|
345
|
August 4, 2023
|
|
Xp_cmdshell problem
|
|
2
|
251
|
August 2, 2023
|
|
Best way to handle incremental duplicate data in SQL Server?
|
|
2
|
254
|
August 2, 2023
|
|
SQL equivalent of MS Excel's VLOOKUP + Replace
|
|
2
|
322
|
August 1, 2023
|
|
How to identify changes
|
|
2
|
154
|
July 26, 2023
|
|
How to import an excel file with hyperlinks to sql server
|
|
5
|
522
|
July 19, 2023
|
|
DELETE with SELECT and join in SQL SERVER
|
|
4
|
247
|
July 19, 2023
|
|
Error in drop temp table in batch
|
|
2
|
202
|
July 16, 2023
|
|
Problem merging two tables with overlapping record validity
|
|
1
|
211
|
July 16, 2023
|
|
Missing Record
|
|
1
|
214
|
July 15, 2023
|
|
Using a stored proc parameter in an SSRS report
|
|
3
|
291
|
July 13, 2023
|
|
Allow a sp to delete records in another database
|
|
3
|
306
|
July 13, 2023
|
|
Simplify Cumbersome Code
|
|
2
|
207
|
July 12, 2023
|
|
Duplicated lines in one
|
|
1
|
238
|
July 11, 2023
|
|
Query to Check for Duplicate Results
|
|
4
|
235
|
July 6, 2023
|
|
Group Rows with Mutual Field Data
|
|
1
|
189
|
July 4, 2023
|
|
Table constrains order
|
|
1
|
260
|
July 4, 2023
|
|
SQL with JSON
|
|
8
|
232
|
July 4, 2023
|
|
Consolidate Results
|
|
1
|
174
|
July 3, 2023
|
|
Report Designer - Excel formulas
|
|
1
|
265
|
July 3, 2023
|
|
Hopefully Simple for Experts (Difficult for Me) - Compare to Prior Day
|
|
1
|
211
|
June 30, 2023
|
|
Substring-select or where
|
|
1
|
197
|
June 30, 2023
|
|
How to delete by combining values with the same department_id?
|
|
1
|
192
|
June 30, 2023
|
|
Ideas
|
|
1
|
247
|
June 30, 2023
|
|
Problem to get data with select
|
|
1
|
208
|
June 30, 2023
|
|
Need help in Row_num increment in insert statement
|
|
2
|
279
|
June 22, 2023
|
|
Mapping two tables dynamically in ms sql
|
|
1
|
284
|
June 30, 2023
|
|
Msg 8120 Error Help
|
|
1
|
216
|
June 30, 2023
|
|
How to design my database
|
|
16
|
255
|
June 29, 2023
|
|
Correcting fact table records that were changed by a user
|
|
5
|
589
|
June 27, 2023
|