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

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 - 535348

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

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

Writing dinamically the table for a select inside a stored procedure - SQL Server 2012
pscorca 16 minutes ago - 232

I need a quick simple primer on retrieving XML data.
falcon00 1 hour 21 minutes ago - 9109

datetime datatype performance issue
ione721 19 hours 37 minutes ago - 5144

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

If Statements not evaluating correctly.
IT Dept GAC 3 hours 8 minutes ago - 6106

TSQL 2008 R2- To condense the table by forming groups without Cursor logic
Aniketm 12 hours 8 minutes ago - 429

Msg 102, Level 15, State 1, Line 17, Any Help is very much appriciated
viveknj 29 minutes ago - 335

Different SUM()'s based on different WHERE -- use subselects?
rick7072 1 hour 28 minutes ago - 230

please explain code
kconwaycole 1 hour 56 minutes ago - 663

Active transaction
simonxy 4 hours 12 minutes ago - 232

Get joined rows with temp table?
SearsKM 1 hour 57 minutes ago - 333

Update Statement not updating all hours
tmacdonaldmpower 2 hours 10 minutes ago - 9109

Minutes between two dates excluding holiday's and outside work hours
reddy5511 Monday, May 20, 2013 5:12 PM - 031

Trigger
Muhammad Saad Ch 2 hours 6 minutes ago - 4121

Return Empty String if any of all columns in select statement is null
Aarsh (MCTS) Tuesday, May 14, 2013 3:04 PM - 565

Moving records - delete and insert in one statement, does this still need wrapped with a transaction?
shiftbit 22 hours 18 minutes ago - 241

Partitioned view : Using check constraint on multiple columns
macfly67 3 hours 1 minutes ago - 5142

How to resolve deadlocks
Mark Roworth 3 Monday, May 20, 2013 3:47 PM - 7188

Trouble with query to aggregate values for filtering... do i need more sql skills or Cross Join, Cross apply, or Pivot/UnPivot
Rogge Thursday, May 16, 2013 6:54 PM - 134819

Indexed View Issue - Error converting data type nvarchar to numeric
Wolfmeister Saturday, May 07, 2011 12:55 PM

