Transact-SQL

TSQL challenges? This is the place for advice and discussions 

• 14569
  

  IDENTITY_INSERT problem when using with EXECUTE statement.

  
  NarendraJ Monday, April 21, 2008 12:53 PM
  Last Reply Adam Haines Monday, April 21, 2008 12:58 PM
 
• 53349
  

  StrdPrcdr Param Get All Values

  
  man-Olie Monday, April 21, 2008 11:27 AM
  Last Reply man-Olie Monday, April 21, 2008 12:31 PM
 
• 1013620
  

  Replace invalid XML characters using SQL query

  
  nisha3 Monday, April 21, 2008 6:15 AM
  Last Reply nisha3 Monday, April 21, 2008 12:26 PM
 
• 23995
  

  Static Analysis of scripts not containing a SQL object Fully Qualified name?

  
  PumpkinHunt Friday, March 21, 2008 4:54 PM
  Last Reply PumpkinHunt Monday, April 21, 2008 12:24 PM
 
• 13689
  

  dynamic sql

  
  Tgnaxin Monday, April 21, 2008 10:59 AM
  Last Reply zuomin Monday, April 21, 2008 11:46 AM
 
• 63431
  

  Simple ALTER Command setting DEFAULT help

  
  OnamC Monday, April 21, 2008 8:29 AM
  Last Reply Jonathan KehayiasMVPMonday, April 21, 2008 10:06 AM
 
• 14243
  

  View with many subqueries

  
  JonShin Sunday, April 20, 2008 9:59 PM
  Last Reply Jonathan KehayiasMVPMonday, April 21, 2008 9:20 AM
 
• 23726
  

  subtotal question

  
  serkandll Monday, April 21, 2008 8:16 AM
  Last Reply VidhyaSagar Monday, April 21, 2008 8:33 AM
 
• 14047
  

  sum in sqlserver with in group

  
  sameer18 Monday, April 21, 2008 6:50 AM
  Last Reply Iain J Monday, April 21, 2008 7:01 AM
 
• 23889
  

  count(*) performance

  
  Kapil K Monday, April 21, 2008 12:07 AM
  Last Reply Kapil K Monday, April 21, 2008 4:15 AM
 
• 73859
  

  Selecting parts of data

  
  a182x Sunday, April 20, 2008 10:17 PM
  Last Reply Adam Haines Monday, April 21, 2008 2:12 AM
 
• 34456
  

  How to find Differences in Column Data types between tables in Two different Databases using TSQL

  
  SQLScript Monday, April 21, 2008 1:26 AM
  Last Reply Adam Haines Monday, April 21, 2008 1:51 AM
 
• 83354
  

  please help Iain J unpivoted pivot check each column succession-problem X

  
  gpspocket Sunday, April 20, 2008 11:55 PM
  Last Reply gpspocket Monday, April 21, 2008 12:36 AM
 
• 34942
  

  How to do Pair-wise comparision Like Oracle in MS Sql server 2000?

  
  D A Friday, April 18, 2008 7:07 AM
  Last Reply Iain J Sunday, April 20, 2008 11:12 PM
 
• 33799
  

  update if exist-one table to another from tow date fields- single row for each day

  
  gpspocket Sunday, April 20, 2008 8:07 PM
  Last Reply gpspocket Sunday, April 20, 2008 11:03 PM
 
• 44067
  

  hide Fname value evry second row

  
  gpspocket Sunday, April 20, 2008 8:23 PM
  Last Reply gpspocket Sunday, April 20, 2008 10:05 PM
 
• 53830
  

  IF Statement out of control

  
  Hoodwinked Friday, April 18, 2008 1:37 AM
  Last Reply Hoodwinked Sunday, April 20, 2008 9:49 PM
 
• 23796
  

  partitioning schema and filegroup management

  
  Alen cappelletti Thursday, January 17, 2008 8:42 AM
  Last Reply HunchbackMVPSunday, April 20, 2008 5:08 PM
 
• 54557
  

  help-insert one table to another from tow date fields- single row for each day

  
  gpspocket Sunday, April 20, 2008 10:45 AM
  Last Reply gpspocket Sunday, April 20, 2008 5:06 PM
 
• 34037
  

  problem calculating the division of 2 columns

  
  Bhaskar Ravindranath Sunday, April 20, 2008 6:59 AM
  Last Reply HunchbackMVPSunday, April 20, 2008 4:38 PM