SQLTeam.com | Weblogs | Forums

Transact-SQL


Getting Duplicates Still with Max (5)
Need help with select case statement (6)
Can You Change A Server Connection From Within A Stored Procedure? (7)
Dynamic Sum and Aggregate (2)
Combine multiple rows into one row in sql (5)
How to improve query performance on a single table with 12M records (11)
How can we learn sql (2)
How to get the desired data with SQL (4)
Subtract by Records (6)
How to split comma separated values stored in XML node Without using function- SQL Server 2012 (3)
SQL Delete (10)
SQL Question (4)
SQL View Order By and Running Total? (2)
Creating Correlated Sub query using Count (8)
Dynamic sql and looping - changing variable name? (13)
Creating a % column on Matrix (3)
Select statment in one alias column (5)
Global field distributed on individual fields (4)
Best practice: single or multiple connections (3)
How to pull last category if multiple ones are present in a current year? (16)
Find and Replace last <N_L> Characters with Hyphen (3)
Case statement in join clause (4)
Need HTML table to be incorporated in query (2)
How to find maximum concurrent users and sessions by Login and Logout Time? (6)
Importing Data to SQL Server from Excel File using VBA (5)
Select distinct on one column get one row (5)
CTE and PIVOT in main query (5)
Help needed with the SQL query (7)
Date different query (10)
Count occurrences of text in a string starting with a number between 1-9 (3)