Transact-SQL

Topic	Replies	Views	Activity
How to get current quarter and prior quarter values	4	883	February 9, 2018
SQL --date incompatible with INT	2	2847	February 9, 2018
Duplicate records	4	516	February 9, 2018
SUM([Qty]) OVER(PARTITION BY - closing stock position sql2014 , sql2012	4	801	February 9, 2018
Join a table to a pivot table result	1	496	February 9, 2018
OPTION (OPTIMIZE FOR ...multiple values for a single parameter)	2	666	February 9, 2018
Performance problem using cursor sql2012	2	479	February 9, 2018
Self-Join with aggregation and maybe pivot?	6	741	February 8, 2018
Encrypt Objects sql2012	20	1292	February 8, 2018
Bulk Insert Multiple pipe delimted files	3	1280	February 6, 2018
Create Student Marks Sheet with data stored row wise	2	3410	February 6, 2018
Beginners question about SQL statement	11	1149	November 4, 2016
T-SQL Question	4	893	February 6, 2018
Recursive CTE	2	477	February 6, 2018
Looking for automatic serial numbers 1,2,3 etc. in query	13	1068	February 6, 2018
Creating a dynamic insert into assigning data to columns sql2008r2	11	965	February 5, 2018
Add_month Convert to SQL	7	902	February 5, 2018
Need help in building sql query which has complex logic sql2008	8	719	February 5, 2018
Using Id's in a Group by statement to count other data	2	558	February 3, 2018
Bcp and long query	4	1582	February 2, 2018
Format of result, head category subcategory'	5	608	February 2, 2018
Exclusion Query	3	457	February 2, 2018
Series of datetime entries in sql - verify available 10 hours in a 24 hour interval	13	1166	January 31, 2018
Adding dash to cast(concat) function	2	1945	January 30, 2018
SQL sub query counting - is there a better way? sql2014	4	620	January 30, 2018
How Do I get original amount based on Posted Date, in an aggregate query?	3	462	January 30, 2018
Error when XML Path within a parameter	5	2957	January 30, 2018
SQL Server View sql2014	2	519	January 29, 2018
Foreign Key Index question	3	472	January 29, 2018
Sql query with date approach sql-server-2014	7	826	January 29, 2018