Transact-SQL

Topic	Replies	Views	Activity
Multiple where not in condition not working sql2012 , sql2008r2 , sql2008	9	946	January 24, 2018
Alternative for LEAD function sql2008r2 , sql2008	2	715	January 24, 2018
Find the latest itemid sql2012 , sql2008r2 , sql2008	6	742	January 23, 2018
Extract information from date	1	454	January 23, 2018
Optimize triangular join in large data	1	600	January 23, 2018
Syntax of cross apply is beyond me	9	821	January 19, 2018
Move one XML node to another	8	1090	January 18, 2018
SQL View for Period Totals when no Record in Totals Table for Period	1	582	January 19, 2018
SQL Pivot	0	408	January 19, 2018
Difference between 2 dates on same column based on value in another column	2	475	January 19, 2018
Round money values to only 2 decimals	2	491	January 19, 2018
Filter query	6	615	January 19, 2018
Products Sold Per Month	15	839	January 19, 2018
ADD_MONTH() to SQL	15	947	January 18, 2018
Need help with Optimizing query	4	534	January 17, 2018
A problem with dates (datetime null) and (datetime not null)	3	2313	January 16, 2018
TSQL Select dateformat?	12	875	January 15, 2018
Crystal Report SQL Query command paramter with formula editor value	2	1926	January 12, 2018
Pivot multiple Rows into multiple column sql2012 , sql2008r2 , tsql	1	592	January 12, 2018
Crossover Dates Problem/Query	5	1089	January 11, 2018
Each GROUP BY expression must contain at least one column that is not an outer reference	4	686	January 10, 2018
How to write a query sum of Logintime and logout time of employee	8	878	January 10, 2018
Update multiple records with select BUT	3	531	January 10, 2018
SQL Query - Two Counts Different Granularity	2	604	January 10, 2018
SQL XML Parsing	1	448	January 10, 2018
Sql case query with different condition with a single column	1	472	January 10, 2018
Update same table each row based on criteria	2	444	January 10, 2018
Puzzling Problem	1	900	January 9, 2018
Missing some rows	2	453	January 9, 2018
Updating primary key value in sql server via stored procedure	4	1431	January 9, 2018