Transact-SQL

TSQL challenges? This is the place for advice and discussions 

• 496
  

  Email alert on schema update

  
  Alvin.Tripp Wednesday, May 22, 2013 8:19 AM
  Last Reply Latheesh NKMicrosoft Community ContributorWednesday, May 22, 2013 8:27 AM
 
• 2112
  

  Identify and Stop stored proc from running

  
  rhchin Tuesday, May 21, 2013 9:30 PM
  Last Reply Kalman TothMicrosoft Community ContributorWednesday, May 22, 2013 7:57 AM
 
• 11185
  

  Conversion failed when converting date and/or time from character string in SQLServer

  
  Ravuri777 Friday, May 17, 2013 7:35 AM
  Last Reply Ravuri777 Wednesday, May 22, 2013 7:48 AM
 
• 6104
  

  How to split one column into several columns by the character ";"

  
  alfred w Wednesday, May 22, 2013 6:34 AM
  Last Reply RSingh() Wednesday, May 22, 2013 7:25 AM
 
• 893
  

  Start with a Null record in a table orijinaly its a not null property

  
  Dynamo70 Wednesday, May 22, 2013 4:52 AM
  Last Reply Dynamo70 Wednesday, May 22, 2013 6:32 AM
 
• 190
  

  SQL Backup Incomplete

  
  J P IT Tuesday, May 21, 2013 7:38 PM
  Last Reply Olaf HelperMicrosoft Community ContributorWednesday, May 22, 2013 5:02 AM
 
• 4138
  

  Get joined rows with temp table?

  
  SearsKM Tuesday, May 21, 2013 4:01 PM
  Last Reply RSingh() Wednesday, May 22, 2013 2:23 AM
 
• 297
  

  How to return date value by going one year back

  
  sandra V O Tuesday, May 21, 2013 11:38 PM
  Last Reply Naomi NMicrosoft Community ContributorWednesday, May 22, 2013 1:55 AM
 
• 284
  

  First transaction in 2012

  
  SBolton Tuesday, May 21, 2013 9:35 PM
  Last Reply Naomi NMicrosoft Community ContributorTuesday, May 21, 2013 10:14 PM
 
• 386
  

  how to update multiple records

  
  sandra V O Tuesday, May 21, 2013 9:21 PM
  Last Reply Naomi NMicrosoft Community ContributorTuesday, May 21, 2013 10:03 PM
 
• 14104
  

  CREATE PROCEDURE - Learning tSQL

  
  PavilionWI Tuesday, May 21, 2013 7:23 PM
  Last Reply disssss Tuesday, May 21, 2013 9:48 PM
 
• 2104
  

  We have the databases with restricted size and someone has changed the max size of the data files or may be created a new data file.

  
  Ajay.G Tuesday, May 21, 2013 3:00 PM
  Last Reply Kalman TothMicrosoft Community ContributorTuesday, May 21, 2013 9:12 PM
 
• 12334
  

  Is there a better way to write this SQL? - I wish to use something other than NOT IN.

  
  lcerni Tuesday, May 14, 2013 3:13 PM
  Last Reply LeeDurrance Tuesday, May 21, 2013 8:09 PM
 
• 10160
  

  Minutes between two dates excluding holiday's and outside work hours

  
  reddy5511 Monday, May 20, 2013 5:12 PM
  Last Reply Marko Frntic Tuesday, May 21, 2013 7:35 PM
 
• 288
  

  Trigger

  
  Muhammad Saad Ch Tuesday, May 21, 2013 3:51 PM
  Last Reply Tom Phillips Tuesday, May 21, 2013 7:20 PM
 
• 591
  

  Msg 102, Level 15, State 1, Line 17, Any Help is very much appriciated

  
  viveknj Tuesday, May 21, 2013 5:28 PM
  Last Reply Tom Phillips Tuesday, May 21, 2013 7:02 PM
 
• 3131
  

  Alter column in a compressed table takes long time

  
  Christa Kurschat Tuesday, May 21, 2013 7:09 AM
  Last Reply Gert-Jan Strik Tuesday, May 21, 2013 6:44 PM
 
• 8179
  

  Looking for simplest method to output a CSV with a title row (not a header row) and footer row

  
  SQL Server dude Monday, May 20, 2013 10:17 PM
  Last Reply SQL Server dude Tuesday, May 21, 2013 6:22 PM
 
• 6226
  

  Remove data (truncate/delete) on tables and Load data SQL Server 2008 R2

  
  SQLDBA321 Monday, May 20, 2013 1:32 AM
  Last Reply Aalam Rangi Tuesday, May 21, 2013 6:22 PM
 
• 389
  

  I need a quick simple primer on retrieving XML data.

  
  falcon00 Tuesday, May 21, 2013 4:37 PM
  Last Reply Stefan HoffmannMVPTuesday, May 21, 2013 6:21 PM