Transact-SQL

Topic	Replies	Views	Activity
How to get current quarter and prior quarter values	4	861	February 9, 2018
SQL --date incompatible with INT	2	2846	February 9, 2018
Duplicate records	4	514	February 9, 2018
SUM([Qty]) OVER(PARTITION BY - closing stock position sql2014 , sql2012	4	787	February 9, 2018
Join a table to a pivot table result	1	486	February 9, 2018
OPTION (OPTIMIZE FOR ...multiple values for a single parameter)	2	665	February 9, 2018
Performance problem using cursor sql2012	2	471	February 9, 2018
Self-Join with aggregation and maybe pivot?	6	722	February 8, 2018
Encrypt Objects sql2012	20	1268	February 8, 2018
Bulk Insert Multiple pipe delimted files	3	1264	February 6, 2018
Create Student Marks Sheet with data stored row wise	2	3408	February 6, 2018
Beginners question about SQL statement	11	1114	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	1027	February 6, 2018
Creating a dynamic insert into assigning data to columns sql2008r2	11	960	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	718	February 5, 2018
Using Id's in a Group by statement to count other data	2	557	February 3, 2018
Bcp and long query	4	1559	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	1152	January 31, 2018
Adding dash to cast(concat) function	2	1944	January 30, 2018
SQL sub query counting - is there a better way? sql2014	4	618	January 30, 2018
How Do I get original amount based on Posted Date, in an aggregate query?	3	461	January 30, 2018
Error when XML Path within a parameter	5	2956	January 30, 2018
SQL Server View sql2014	2	518	January 29, 2018
Foreign Key Index question	3	469	January 29, 2018
Sql query with date approach sql-server-2014	7	807	January 29, 2018