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.
- 8237

Are you a technology guru? Show us your solutions, win awards, become Guru of the Month!!
XAML guyMicrosoft Community ContributorMonday, May 20, 2013 10:24 AM - 535384

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

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

how to exclude unwanted data
sandra V O 5 hours 49 minutes ago - 357

sys.dm_exec_query_stats query indicates stored procedure is being re-compiled frequently?
shiftbit 4 hours 21 minutes ago - 017

Do index intermediate levels reflect the delete changes immediately, or after ghost-cleanup process finish deleted-records cleanup process?
黄孟 1 hour 16 minutes ago - 36195

identity on case sensitive varchar field
elnath1978 14 hours 24 minutes ago - 358

Sum in SQL
Nil35 5 hours 46 minutes ago - 15140

Will we ever be able to directly ORDER BY @SortExpression ?
John 09 21 hours 26 minutes ago - 784

SQL Server 2005: Arithmetic overflow error converting int to data type numeric
CTBarbarin 7 hours 10 minutes ago - 773

How to pass a default value to Select Statement in SQL Server Procedure
canchiru 6 hours 1 minutes ago - 132

What would be the best way to process 10000 records with multiple processes
maykino 4 hours 35 minutes ago - 129

Using a value from a table in CmdExed step?
StevieKideckel 5 hours 36 minutes ago - 131

SET Quoted Identifier Error When SQL Agent Job Runs vs. In SSMS
Lee Markum 4 hours 28 minutes ago - 594

SQL String Manipulation
Ozkantr 7 hours 36 minutes ago - 026

Restore from FULL Backup and restore all TLOG backups after Full Backup
Manuji 4 hours 14 minutes ago - 476

Challenge: how to count NULLs for each column in every table in VLDB etc.
Great Scott1 10 hours 17 minutes ago - 9143

Need help to write a query
Jitta Rohan Wednesday, May 15, 2013 1:21 PM - 344

Doing math with bigint and int datatypes
shiftbit 4 hours 56 minutes ago - 359

Alternative to using UNION here?
rick7072 6 hours 40 minutes ago - 34223

If Statements not evaluating correctly.
IT Dept GAC Tuesday, May 21, 2013 2:50 PM - 6110

Nested Recursive Query
Guyatplacedotcom Tuesday, May 21, 2013 9:50 PM - 256

SQL Server CTE Problem
durgap 7 hours 6 minutes ago

