Transact-SQL

TSQL challenges? This is the place for advice and discussions 

• 5224
  

  MSDTC Fail

  
  swivan 09 Mei 2013 7:17
  Balasan Terakhir swivan 20 Mei 2013 3:07
 
• 4148
  

  Using the fully qualified names in T-SQL

  
  Samijf 19 Mei 2013 22:06
  Balasan Terakhir Tom CooperMicrosoft Community Contributor20 Mei 2013 2:24
 
• 3136
  

  Sending the Query results in HTML format using DBmail

  
  dvsrk 19 Mei 2013 20:52
  Balasan Terakhir dvsrk 20 Mei 2013 0:15
 
• 4228
  

  UPdate with multiple tables

  
  PetraTiburcia 17 Mei 2013 5:34
  Balasan Terakhir --CELKO--Microsoft Community Contributor19 Mei 2013 23:25
 
• 11263
  

  Help with T-SQL script to sum the column values whose cloumn names are dynamically populated.

  
  dvsrk 16 Mei 2013 20:43
  Balasan Terakhir --CELKO--Microsoft Community Contributor19 Mei 2013 22:50
 
• 6197
  

  Invalid object name 'sys.dm_db_stats_properties'

  
  tommyfly 16 Mei 2013 10:25
  Balasan Terakhir Naomi NMicrosoft Community Contributor19 Mei 2013 21:15
 
• 4224
  

  Generating custom output from SQL SELECT

  
  dvsrk 19 Mei 2013 4:15
  Balasan Terakhir dvsrk 19 Mei 2013 20:16
 
• 18236
  

  server and database is case sensitive, but queries and unique constraints not

  
  AlvaroCompton 16 Mei 2013 18:23
  Balasan Terakhir Chris Sijtsma 19 Mei 2013 19:47
 
• 4199
  

  ranking

  
  love4csharp 15 Mei 2013 18:29
  Balasan Terakhir Naomi NMicrosoft Community Contributor19 Mei 2013 19:08
 
• 1118
  

  MSDN branding footprint narrower

  
  Tom CooperMicrosoft Community Contributor19 Mei 2013 17:35
  Balasan Terakhir Dan GuzmanMVP19 Mei 2013 18:01
 
• 14286
  

  Insert Query

  
  Anil Pomar 16 Mei 2013 13:02
  Balasan Terakhir Naomi NMicrosoft Community Contributor19 Mei 2013 17:17
 
• 9155
  

  Dynamic Columns and Rows

  
  siera_gld 10 Mei 2013 5:43
  Balasan Terakhir Kalman TothMicrosoft Community Contributor19 Mei 2013 17:16
 
• 7241
  

  Check the existence of association combinations from a table

  
  SujithPit 07 Mei 2013 4:20
  Balasan Terakhir Kalman TothMicrosoft Community Contributor19 Mei 2013 17:09
 
• 7348
  

  Trigger generates transaction deadlocked.

  
  Gilberto H_ 10 Mei 2013 21:14
  Balasan Terakhir Kalman TothMicrosoft Community Contributor19 Mei 2013 17:02
 
• 9266
  

  Assign conditional allocation value within Select query

  
  OldEnthusiast 18 Mei 2013 5:41
  Balasan Terakhir --CELKO--Microsoft Community Contributor19 Mei 2013 13:55
 
• 5157
  

  got Subqueries are not allowed in this context. Only scalar expressions are allowed

  
  Aprijal 17 Mei 2013 14:43
  Balasan Terakhir Naomi NMicrosoft Community Contributor19 Mei 2013 13:52
 
• 4168
  

  Copy all tables with names begins with a given string

  
  stephen huo 17 Mei 2013 10:16
  Balasan Terakhir Naomi NMicrosoft Community Contributor19 Mei 2013 13:19
 
• 3206
  

  Multiple values separated by a comma for an ID in my table

  
  SqlCraze 19 Mei 2013 6:47
  Balasan Terakhir --CELKO--Microsoft Community Contributor19 Mei 2013 12:54
 
• 3152
  

  Tsql query for Pivot table help

  
  xXShanXx 18 Mei 2013 15:51
  Balasan Terakhir Ahsan Kabir 19 Mei 2013 10:49
 
• 9340
  

  Match *any* three columns

  
  amosmax 17 Mei 2013 19:34
  Balasan Terakhir davidbaxterbrowneMicrosoft Employee19 Mei 2013 3:14