Transact-SQL

Topic	Replies	Views	Activity
Complex Pivot - Based on Previous Row value tsql	1	543	February 21, 2018
Assign case to user with lowest count sql2012	2	440	February 21, 2018
Delete data with the same month	3	520	February 21, 2018
Query regarding specific case in joining two tables	8	522	February 21, 2018
Conditional Scoring	1	417	February 20, 2018
Need help getting results to one row	4	519	February 20, 2018
Build SQL from a table sql2016	2	665	February 20, 2018
Yesterdays Date (most of the time)	5	783	February 20, 2018
How to mirror a report requirement in MS EXCEL in SQL SERVER 2012	10	672	February 20, 2018
Select Maximum Dates only	5	531	February 20, 2018
Complex Pivot - Based on Row value tsql , sql2012	2	480	February 19, 2018
Try catch	2	447	February 17, 2018
Current Year minus Start Year	5	545	February 16, 2018
Pull Records based on defined hierarchy	3	399	February 16, 2018
Add a sum() column in select statement	1	393	February 16, 2018
Equivalent to an Excel function	4	737	February 15, 2018
Filtering a query to present one-to-many data as one-to-one	3	428	February 15, 2018
Add days till next month to the date	3	450	February 15, 2018
Average number per hour between two datetimes	2	457	February 15, 2018
Period in Stored Procedure parameter	1	546	February 14, 2018
Capitalizing string	3	501	February 11, 2018
Get a subset or group of data based on ID and only the first "group"	4	480	February 10, 2018
How to get current quarter and prior quarter values	4	831	February 9, 2018
SQL --date incompatible with INT	2	2811	February 9, 2018
Duplicate records	4	502	February 9, 2018
SUM([Qty]) OVER(PARTITION BY - closing stock position sql2014 , sql2012	4	771	February 9, 2018
Join a table to a pivot table result	1	480	February 9, 2018
OPTION (OPTIMIZE FOR ...multiple values for a single parameter)	2	659	February 9, 2018
Performance problem using cursor sql2012	2	467	February 9, 2018
Self-Join with aggregation and maybe pivot?	6	711	February 8, 2018