Transact-SQL
TSQL challenges? This is the place for advice and discussions
Filtering and SortingUse these options to narrow down the question and discussion list.
- 4125

Are you a technology guru? Show us your solutions, win awards, become Guru of the Month!!
XAML guyMicrosoft Community Contributor20 hours 27 minutes ago - 435315

POSTING TIPS - source code, screen images, details within...
Phil BrammerMVPTuesday, December 01, 2009 10:19 PM - 053992

Solutions to Common T-SQL Problems
Arnie RowlandMVPSaturday, April 12, 2008 2:52 PM - 448

TSQL - To condense the table by forming groups without Cursor logic
Aniketm 1 hour 2 minutes ago - 343

Count query
Vipin jha 31 minutes ago - 2136

Query Optimization
Kumar14 Saturday, May 18, 2013 6:56 PM - 21157

Getting query result set faster from table
NoorBi 19 hours 29 minutes ago - 638

Need help in writing a query
Deepika Karanth1 56 minutes ago - 13269

SQL-Update using above rows
Rihan8585 Wednesday, May 15, 2013 10:04 AM - 10108

How to iterate through multiple linked server to fetch the data for simple SQL query
UltraDev 18 hours 35 minutes ago - 9122

Update query using Case?
Srikanthd5 20 hours 3 minutes ago - 658

Nested CASE in ORDER BY
John 09 3 hours 1 minutes ago - 655

subquery
Dynamo70 2 hours 55 minutes ago - 485

shall we convert the below update query into OpenQuery.
RoyalM 21 hours 40 minutes ago - 475

How to capture the decimal value
MarkAravind 3 hours 48 minutes ago - 361

Looking for simplest method to output a CSV with a title row (not a header row) and footer row
SQL Server dude 8 hours 34 minutes ago - 232

date convert to German format failing
Vaishu 4 hours 29 minutes ago - 4121

Remove data (truncate/delete) on tables and Load data SQL Server 2008 R2
SQLDBA321 Monday, May 20, 2013 1:32 AM - 574

datetime datatype performance issue
ione721 8 hours 30 minutes ago - 378

Grouping with Case or If in TSQL
karon1980 10 hours 22 minutes ago - 268

How to resolve deadlocks
Mark Roworth 3 15 hours 4 minutes ago - 148

select top 1 salary from each department
tsql_new 7 hours 19 minutes ago - 244

Want to calculate in meters with geography::Point
Kashif Chotu 8 hours 25 minutes ago

