Transact-SQL

TSQL challenges? This is the place for advice and discussions 

• 6145
  

  Computed column vs trigger -- Performance question.

  
  Gilberto H_ Friday, May 24, 2013 7:17 PM
  Last Reply --CELKO--Microsoft Community Contributor22 hours 46 minutes ago
 
• 15167
  

  sql -Join To get all Records

  
  Rihan8585 Friday, May 24, 2013 10:27 AM
  Last Reply José_Diz 22 hours 52 minutes ago
 
• 1110
  

  Parameters with sql

  
  FabioHN Thursday, May 23, 2013 7:25 PM
 
• 16259
  

  TSQL 2008 R2- To condense the table by forming groups without Cursor logic

  
  Aniketm Tuesday, May 21, 2013 5:49 AM
  Last Reply Gert-Jan Strik Friday, May 24, 2013 8:07 PM
 
• 5109
  

  Partitioned views : how to filter on the partition key in a stored procedure ?

  
  macfly67 Thursday, May 23, 2013 3:45 PM
  Last Reply Gert-Jan Strik Friday, May 24, 2013 8:02 PM
 
• 291
  

  update output into

  
  TobarWme Friday, May 24, 2013 6:11 PM
  Last Reply Latheesh NKMicrosoft Community ContributorFriday, May 24, 2013 6:33 PM
 
• 4108
  

  XML header information into tablw

  
  Vaishu Friday, May 24, 2013 12:17 PM
  Last Reply wBobMicrosoft Community ContributorFriday, May 24, 2013 5:00 PM
 
• 171
  

  Multiple Select statements within an IF statement

  
  mielkeac Friday, May 24, 2013 4:38 PM
  Last Reply Naomi NMicrosoft Community ContributorFriday, May 24, 2013 4:41 PM
 
• 5108
  

  Truncating VARCHAR(max)

  
  mielkeac Friday, May 24, 2013 3:07 PM
  Last Reply Tom CooperMicrosoft Community ContributorFriday, May 24, 2013 4:29 PM
 
• 477
  

  Saving very large file out

  
  SBolton Friday, May 24, 2013 2:36 PM
  Last Reply Johnny Bell Jnr Friday, May 24, 2013 3:50 PM
 
• 581
  

  Append Comma after EVERY FieldName in TSQL

  
  Desigal59 Friday, May 24, 2013 2:44 PM
  Last Reply davidbaxterbrowneMicrosoft EmployeeFriday, May 24, 2013 3:14 PM
 
• 6231
  

  Concatenation in where clause

  
  Pundrick Thursday, May 23, 2013 10:41 PM
  Last Reply Gert-Jan Strik Friday, May 24, 2013 3:06 PM
 
• 10146
  

  What data type is optimal for clustered index of a table published by using transactional replication?

  
  AlexeyGa Wednesday, May 22, 2013 8:14 PM
  Last Reply Gert-Jan Strik Friday, May 24, 2013 2:58 PM
 
• 2133
  

  strange parallel repartition streams behaviour

  
  ChrisAdkin Thursday, May 23, 2013 3:55 PM
  Last Reply Gert-Jan Strik Friday, May 24, 2013 2:45 PM
 
• 3153
  

  SQl Server 2008 Performance Issue for Count(distinct()) and SUM() functions. How can I avoid these issues?

  
  sivaraman8282 Wednesday, May 22, 2013 8:09 AM
  Last Reply Gert-Jan Strik Friday, May 24, 2013 2:36 PM
 
• 389
  

  EXEC OPENDATASOURCE INSERT TABLE

  
  Pokemon_RIZA Friday, May 24, 2013 12:13 PM
  Last Reply RSingh() Friday, May 24, 2013 1:22 PM
 
• 486
  

  how to use or conver axisting access database with sql server 2005

  
  haqayyum Friday, May 24, 2013 11:14 AM
  Last Reply Jesús López Friday, May 24, 2013 11:59 AM
 
• 5116
  

  When run batch sql statements, how get rows affected for each update statement?

  
  Karry_Wong Friday, May 24, 2013 8:30 AM
  Last Reply Dan GuzmanMVPFriday, May 24, 2013 11:23 AM
 
• 579
  

  Convert Float date time to readable format

  
  donk04 Friday, May 24, 2013 10:37 AM
  Last Reply donk04 Friday, May 24, 2013 11:13 AM
 
• 4210
  

  Joining Calender table

  
  aivoryuk Tuesday, March 19, 2013 7:21 PM
  Last Reply aivoryuk Friday, May 24, 2013 10:33 AM