|
Query regarding specific case in joining two tables
|
|
8
|
520
|
February 21, 2018
|
|
Conditional Scoring
|
|
1
|
417
|
February 20, 2018
|
|
Need help getting results to one row
|
|
4
|
517
|
February 20, 2018
|
|
Build SQL from a table
|
|
2
|
665
|
February 20, 2018
|
|
Yesterdays Date (most of the time)
|
|
5
|
782
|
February 20, 2018
|
|
How to mirror a report requirement in MS EXCEL in SQL SERVER 2012
|
|
10
|
671
|
February 20, 2018
|
|
Select Maximum Dates only
|
|
5
|
528
|
February 20, 2018
|
|
Complex Pivot - Based on Row value
|
|
2
|
480
|
February 19, 2018
|
|
Try catch
|
|
2
|
446
|
February 17, 2018
|
|
Current Year minus Start Year
|
|
5
|
545
|
February 16, 2018
|
|
Pull Records based on defined hierarchy
|
|
3
|
396
|
February 16, 2018
|
|
Add a sum() column in select statement
|
|
1
|
392
|
February 16, 2018
|
|
Equivalent to an Excel function
|
|
4
|
711
|
February 15, 2018
|
|
Filtering a query to present one-to-many data as one-to-one
|
|
3
|
427
|
February 15, 2018
|
|
Add days till next month to the date
|
|
3
|
450
|
February 15, 2018
|
|
Average number per hour between two datetimes
|
|
2
|
456
|
February 15, 2018
|
|
Period in Stored Procedure parameter
|
|
1
|
542
|
February 14, 2018
|
|
Capitalizing string
|
|
3
|
497
|
February 11, 2018
|
|
Get a subset or group of data based on ID and only the first "group"
|
|
4
|
479
|
February 10, 2018
|
|
How to get current quarter and prior quarter values
|
|
4
|
752
|
February 9, 2018
|
|
SQL --date incompatible with INT
|
|
2
|
2770
|
February 9, 2018
|
|
Duplicate records
|
|
4
|
501
|
February 9, 2018
|
|
SUM([Qty]) OVER(PARTITION BY - closing stock position
|
|
4
|
771
|
February 9, 2018
|
|
Join a table to a pivot table result
|
|
1
|
476
|
February 9, 2018
|
|
OPTION (OPTIMIZE FOR ...multiple values for a single parameter)
|
|
2
|
649
|
February 9, 2018
|
|
Performance problem using cursor
|
|
2
|
465
|
February 9, 2018
|
|
Self-Join with aggregation and maybe pivot?
|
|
6
|
703
|
February 8, 2018
|
|
Encrypt Objects
|
|
20
|
1218
|
February 8, 2018
|
|
Bulk Insert Multiple pipe delimted files
|
|
3
|
1254
|
February 6, 2018
|
|
Create Student Marks Sheet with data stored row wise
|
|
2
|
3375
|
February 6, 2018
|