SQLTeam.com | Weblogs | Forums

Transact-SQL


About the Transact-SQL category (1)
Yesterdays Date (most of the time) (4)
Try catch (3)
Current Year minus Start Year (6)
Pull Records based on defined hierarchy (4)
Add a sum() column in select statement (2)
Equivalent to an Excel function (5)
Select Maximum Dates only (5)
Filtering a query to present one-to-many data as one-to-one (4)
Add days till next month to the date (4)
Average number per hour between two datetimes (3)
Period in Stored Procedure parameter (2)
Capitalizing string (4)
Get a subset or group of data based on ID and only the first "group" (5)
How to get current quarter and prior quarter values (5)
SQL --date incompatible with INT (3)
Duplicate records (5)
SUM([Qty]) OVER(PARTITION BY - closing stock position (5)
Join a table to a pivot table result (2)
OPTION (OPTIMIZE FOR ...multiple values for a single parameter) (3)
Performance problem using cursor (3)
Self-Join with aggregation and maybe pivot? (7)
Encrypt Objects ( 2 ) (21)
Bulk Insert Multiple pipe delimted files (4)
Create Student Marks Sheet with data stored row wise (3)
Beginners question about SQL statement (12)
T-SQL Question (5)
Recursive CTE (3)
Looking for automatic serial numbers 1,2,3 etc. in query (14)
Creating a dynamic insert into assigning data to columns (12)