Transact-SQL

TSQL challenges? This is the place for advice and discussions 

• 262607
  

  Some guidlines for posting questions...

  
  Clifford Dibble - MSFTMicrosoft EmployeeFriday, October 28, 2005 4:58 PM
  Last Reply Kalman TothMicrosoft Community ContributorMonday, March 18, 2013 9:08 PM
 
• 134989
  

  POSTING TIPS - source code, screen images, details within...

  
  Phil BrammerMVPTuesday, December 01, 2009 10:19 PM
  Last Reply Kalman TothMicrosoft Community ContributorSaturday, February 02, 2013 3:57 PM
 
• 053537
  

  Solutions to Common T-SQL Problems

  
  Arnie RowlandMVPSaturday, April 12, 2008 2:52 PM
 
• 429
  

  DATEDIFF

  
  PMunshi 32 minutes ago
  Last Reply PMunshi 4 minutes ago
 
• 231
  

  Find Duplicate Active records for history data

  
  Raminder 40 minutes ago
  Last Reply Tom CooperMicrosoft Community Contributor21 minutes ago
 
• 23198
  

  tsql - is there a better way for these queries

  
  berli Monday, May 06, 2013 9:01 AM
  Last Reply Naomi NMicrosoft Community Contributor30 minutes ago
 
• 131
  

  Full Text Search does not return expected results on production server

  
  krishna1216 2 hours 50 minutes ago
  Last Reply wBobMicrosoft Community Contributor38 minutes ago
 
• 10120
  

  tricky update?

  
  cwmizner 13 hours 41 minutes ago
  Last Reply cwmizner 57 minutes ago
 
• 026
  

  CREATE DATABASE AUDIT SPECIFICATION for all tables?

  
  Tom Groszko 1 hour 20 minutes ago
 
• 758
  

  Self Referential Select possible?

  
  gwblack 2 hours 4 minutes ago
  Last Reply gwblack 1 hour 24 minutes ago
 
• 698
  

  calculate the size of tables in bytes

  
  Wallace Chan Monday, May 06, 2013 6:00 AM
  Last Reply Karthick P.K - karthick krishnamurthyMicrosoft Employee1 hour 32 minutes ago
 
• 564
  

  Query to get Distinct Values

  
  diddi10 2 hours 53 minutes ago
  Last Reply Russell FieldsMVP2 hours 8 minutes ago
 
• 794
  

  Need To Get Folder and Subfolders List

  
  Amarnath M 8 hours 59 minutes ago
  Last Reply RSingh() 2 hours 26 minutes ago
 
• 669
  

  With in sql query

  
  selvakumars 5 hours 42 minutes ago
  Last Reply Andre Ranieri 2 hours 33 minutes ago
 
• 7167
  

  Problem with Full text index in Sql server...

  
  Queriessqlserver Monday, May 06, 2013 6:07 AM
  Last Reply wBobMicrosoft Community Contributor2 hours 39 minutes ago
 
• 5162
  

  Query running slow

  
  anaylor01 23 hours 24 minutes ago
  Last Reply Andre Ranieri 2 hours 44 minutes ago
 
• 763
  

  trigger problem

  
  love4csharp 5 hours 5 minutes ago
  Last Reply love4csharp 3 hours 7 minutes ago
 
• 756
  

  How Identity column value reset with last value of column and get the current pointer value of the column

  
  PraveshVijay 5 hours 14 minutes ago
  Last Reply PraveshVijay 3 hours 13 minutes ago
 
• 153
  

  Syntax assistance please

  
  MikeMillerJ 4 hours 49 minutes ago
  Last Reply Dolfie99 3 hours 28 minutes ago
 
• 137
  

  ASP + SQL 2008 data base connection in STORED PROCEDURE

  
  boraemi 3 hours 58 minutes ago
  Last Reply Rechousa 3 hours 38 minutes ago
 
• 5140
  

  Issue in single quoted text in sql server 2008 R2

  
  Navale Chetan Monday, May 06, 2013 11:44 AM
  Last Reply Sebastian Sajaroff 3 hours 59 minutes ago
 
• 251
  

  writing from TSQL stp

  
  opaklaus 5 hours 12 minutes ago
  Last Reply eralper 4 hours 6 minutes ago
 
• 9117
  

  insert prbolem

  
  love4csharp 21 hours 29 minutes ago
  Last Reply Prashant_4dec 4 hours 42 minutes ago