SQLTeam.com | Weblogs | Forums

Transact-SQL


About the Transact-SQL category (1)
Alternative for LEAD function (1)
Find the latest itemid (6)
Handle XML to SQL output (14)
Syntax of cross apply is beyond me (10)
Move one XML node to another (9)
SQL View for Period Totals when no Record in Totals Table for Period (2)
SQL Pivot (1)
Difference between 2 dates on same column based on value in another column (3)
Round money values to only 2 decimals (3)
Filter query (7)
Products Sold Per Month (16)
Grouping start and end times for locations (6)
ADD_MONTH() to SQL (16)
Struggling to remove duplicates (5)
Need help with Optimizing query (5)
Multiple where not in condition not working (5)
A problem with dates (datetime null) and (datetime not null) (4)
TSQL Select dateformat? (13)
Series of datetime entries in sql - verify available 10 hours in a 24 hour interval (10)
Crystal Report SQL Query command paramter with formula editor value (3)
Pivot multiple Rows into multiple column (2)
Select distinct on one column get one row (2)
Crossover Dates Problem/Query (6)
Each GROUP BY expression must contain at least one column that is not an outer reference (5)
How to write a query sum of Logintime and logout time of employee (9)
Update multiple records with select BUT (4)
SQL Query - Two Counts Different Granularity (3)
SQL XML Parsing (2)
Sql case query with different condition with a single column (2)