Transact-SQL

Topic	Replies	Views	Activity
How to get current quarter and prior quarter values	4	899	February 9, 2018
SQL --date incompatible with INT	2	2853	February 9, 2018
Duplicate records	4	518	February 9, 2018
SUM([Qty]) OVER(PARTITION BY - closing stock position sql2014 , sql2012	4	806	February 9, 2018
Join a table to a pivot table result	1	500	February 9, 2018
OPTION (OPTIMIZE FOR ...multiple values for a single parameter)	2	674	February 9, 2018
Performance problem using cursor sql2012	2	487	February 9, 2018
Self-Join with aggregation and maybe pivot?	6	752	February 8, 2018
Encrypt Objects sql2012	20	1343	February 8, 2018
Bulk Insert Multiple pipe delimted files	3	1286	February 6, 2018
Create Student Marks Sheet with data stored row wise	2	3413	February 6, 2018
Beginners question about SQL statement	11	1164	November 4, 2016
T-SQL Question	4	893	February 6, 2018
Recursive CTE	2	479	February 6, 2018
Looking for automatic serial numbers 1,2,3 etc. in query	13	1077	February 6, 2018
Creating a dynamic insert into assigning data to columns sql2008r2	11	977	February 5, 2018
Add_month Convert to SQL	7	960	February 5, 2018
Need help in building sql query which has complex logic sql2008	8	749	February 5, 2018
Using Id's in a Group by statement to count other data	2	567	February 3, 2018
Bcp and long query	4	1593	February 2, 2018
Format of result, head category subcategory'	5	608	February 2, 2018
Exclusion Query	3	467	February 2, 2018
Series of datetime entries in sql - verify available 10 hours in a 24 hour interval	13	1197	January 31, 2018
Adding dash to cast(concat) function	2	1947	January 30, 2018
SQL sub query counting - is there a better way? sql2014	4	624	January 30, 2018
How Do I get original amount based on Posted Date, in an aggregate query?	3	463	January 30, 2018
Error when XML Path within a parameter	5	2965	January 30, 2018
SQL Server View sql2014	2	519	January 29, 2018
Foreign Key Index question	3	494	January 29, 2018
Sql query with date approach sql-server-2014	7	852	January 29, 2018