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

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

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

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

bad example or lack of understanding??
dob_xml 4 hours 22 minutes ago - 10130

What's the best way to compare two numbers
Lin215 10 hours 13 minutes ago - 439

What Happens Behind the Scenes With PIVOT?
Nathon Dalton 1 hour 36 minutes ago - 233

How to Convert the DateTime Value into the Fiscal Year ???????
Wazid Ali 1 hour 0 minutes ago - 1169

SQL Union Statement does not work as expected
z0802361 1 hour 41 minutes ago - 121

How to resolve deadlocks
Mark Roworth 3 1 hour 15 minutes ago - 3130

Transaction (Process ID 95) was deadlocked on lock
CurtisDeHaven Sunday, May 19, 2013 11:45 AM - 120

Query to sum values from dynamic columns
TruncatedHype 1 hour 26 minutes ago - 1062

Insert Trigger
srisql 2 hours 34 minutes ago - 10418

I want to Optimise the below Query ??????
Wazid Ali Friday, April 05, 2013 9:26 AM - 5150

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

How to Retrive the file name from given file path?
SrujanM 9 hours 31 minutes ago - 9105

how to Select Count between Time
No_Dev 5 hours 44 minutes ago - 567

How to Copy a Database from an existing database
Das Thakur 8 hours 4 minutes ago - 4192

Need help with the TSQL.
NguyenBL Friday, May 17, 2013 9:10 PM - 14116

Common Table Expression Help
Jon Bellamy 6 hours 20 minutes ago - 270

How to select corresponding value of max date in group by (the most recent this and that)
Manc4Ever 5 hours 34 minutes ago - 12155

How can I speed up this date-range intersect query?
KippOW Friday, May 17, 2013 6:26 PM - 1182

Getting query result set faster from table
NoorBi 5 hours 40 minutes ago - 1277

Encoding Issue
SanthoshH 5 hours 47 minutes ago

