Transact-SQL

TSQL challenges? This is the place for advice and discussions 

• 13857
  

  Selecting Multiple column from Sub Query.

  
  Mohan1975 Thursday, April 17, 2008 3:31 PM
  Last Reply Mohan1975 Thursday, April 17, 2008 4:28 PM
 
• 64678
  

  Use DateDiff to get Age In Months

  
  xr280xr Wednesday, April 16, 2008 9:53 PM
  Last Reply xr280xr Thursday, April 17, 2008 3:49 PM
 
• 23957
  

  How to execute a stored procedure with output parameter

  
  spitzmann Thursday, April 17, 2008 3:40 PM
  Last Reply David Dye Thursday, April 17, 2008 3:47 PM
 
• 53576
  

  optional where clause

  
  pak1234 Thursday, April 17, 2008 2:48 PM
  Last Reply Aaron Alton Thursday, April 17, 2008 3:08 PM
 
• 164602
  

  SQL job fails after 4 failed Exec() calls

  
  st8floorsup Wednesday, April 16, 2008 9:55 PM
  Last Reply st8floorsup Thursday, April 17, 2008 2:08 PM
 
• 23747
  

  Problem printing @@ROWCOUNT

  
  Flea_ Thursday, April 17, 2008 1:47 PM
  Last Reply Flea_ Thursday, April 17, 2008 2:03 PM
 
• 53661
  

  LTRIM all tables with ID Field

  
  PaulStasny Thursday, April 17, 2008 5:30 AM
  Last Reply Adam Haines Thursday, April 17, 2008 1:52 PM
 
• 33872
  

  Date in current year or last two months

  
  Jon Royales Thursday, April 17, 2008 1:21 PM
  Last Reply SQL_MenaceMVPThursday, April 17, 2008 1:33 PM
 
• 23668
  

  Performance on Inner Join

  
  Bob Cark Thursday, April 17, 2008 12:58 PM
  Last Reply Kent Waldrop _ Thursday, April 17, 2008 1:25 PM
 
• 96970
  

  Calculate minutes in stored procedure using datediff

  
  ron.asp Tuesday, April 15, 2008 8:40 PM
  Last Reply ron.asp Thursday, April 17, 2008 1:22 PM
 
• 73401
  

  Auditing Trigger

  
  Carlos Adriano Portes Thursday, April 17, 2008 1:00 PM
  Last Reply Jonathan KehayiasMVPThursday, April 17, 2008 1:07 PM
 
• 93868
  

  Build a table view from 2 others tables ???

  
  Serge Calderara Thursday, April 17, 2008 11:45 AM
  Last Reply Kent Waldrop _ Thursday, April 17, 2008 12:52 PM
 
• 36215
  

  How do I handle REPLACE a particuler matched string within an NTEXT column in SQL Server?

  
  Anil Dwivedi Thursday, March 27, 2008 5:36 AM
  Last Reply Anil Dwivedi Thursday, April 17, 2008 9:51 AM
 
• 83926
  

  How to read text inside HTML files

  
  Packet8i Wednesday, April 16, 2008 11:00 PM
  Last Reply Hilary CotterMVPThursday, April 17, 2008 9:26 AM
 
• 33808
  

  how to make this join statement in SQL

  
  meta_alucard Tuesday, April 15, 2008 6:17 AM
  Last Reply meta_alucard Thursday, April 17, 2008 8:04 AM
 
• 26665
  

  Warning: The table 'PropertyInstancesAudits' has been created but its maximum row size (8190) exceeds

  
  Manoj Deshpande Thursday, April 17, 2008 6:20 AM
  Last Reply zuomin Thursday, April 17, 2008 7:17 AM
 
• 134252
  

  data lost automatically?

  
  JKwe Thursday, April 17, 2008 6:14 AM
  Last Reply JKwe Thursday, April 17, 2008 7:04 AM
 
• 33738
  

  can sql server know when the row in table Saved \ CREATE TRIGGER date time on the ROW ?

  
  gpspocket Thursday, April 17, 2008 5:40 AM
  Last Reply gpspocket Thursday, April 17, 2008 6:34 AM
 
• 33623
  

  Beep sound

  
  senthilkr Thursday, April 17, 2008 5:50 AM
  Last Reply senthilkr Thursday, April 17, 2008 6:19 AM
 
• 63623
  

  Temporary table and Table variable

  
  senthilkr Monday, April 14, 2008 1:40 PM
  Last Reply senthilkr Thursday, April 17, 2008 5:49 AM