T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Remove records where not have same value in common.

  I have 3 fields (with sample data) RegimenID, DrugID, Country ======================= 1, 22, US 1, …

  patrick ryan-390269

  1 replies

  17 years ago

  By: dmc-608719

• DELETE ... FROM ... JOIN (explanation needed)

  Hi, When you issue a statement such as: DELETE TableA FROM TableA INNER JOIN TableB ON TableA.a = T…

  mrlucmorin

  8 replies

  17 years ago

  By: RBarryYoung

• How do I code this .....?

  I need a query to select the Badge, record number of the person's last log entry, grouped by badge …

  rtbergeron

  8 replies

  17 years ago

  By: GSquared

• delete txt files created by SQL Job using xp_delete_file with SP3

  Hi, I am trying to use the code below to delete log files that have been created by some of my jobs…

  Footprints

  1 replies

  17 years ago

  By: Daniel Claus

• Help with "Reverse Tally" or Creating a Comma Seperated list of values

  Say you have a table with time oriented data (columns would be time period, and value), and you wan…

  Tom Bakerman

  7 replies

  17 years ago

  By: LutzM

• Subset Sum without Cursor

  Still on my quest to remove all the cursors from my database... or at least be capable of removing …

  Shawn Therrien

  21 replies

  17 years ago

  By: RBarryYoung

• Is it possible to add more totals to the following PIVOT ?

  Hi all, I am facing a problem at work atm, where I have a requirement to produce a report for the c…

  sabertra

  3 replies

  17 years ago

  By: sabertra

• SET vs SELECT

  I looked around here a bit to see if anyone had posted anything about what is better: SET or SELECT…

  Noffer

  82 replies

  17 years ago

  By: Noffer

• Find # of active days based on status records

  Given the following table structure and data sample, I need to find the number of days consumers we…

  John Deupree

  14 replies

  17 years ago

  By: Goldie Lesser

• Error Handling

  How could I instruct a sp to coninue execution even if it faces an error.. I am looking for the sam…

  CDBA

  2 replies

  17 years ago

  By: CDBA

• Errors Using XML Schema Collection (Msg 6913)

  I am working with SQL Server 2008 Express and I am having issues with loading an XML schema in and …

  SQL Espo

  2 replies

  17 years ago

  By: PDav

• Combining Records

  I have a client whos database table uses a multicolumn PK. Unfortunately, the columns used for the…

  Ray Laubert

  1 replies

  17 years ago

  By: Florian Reischl

• problem with update script

  I am trying to perform an update in an access 2007 database but I get an error stating missing oper…

  dndaughtery

  1 replies

  17 years ago

  By: Mayank Khatri

• Matrix multiplication without cursors?

  I could use some design direction here: Original design of my db for this client: One person has 12…

  PhilM99

  40 replies

  17 years ago

  By: RBarryYoung

• Concurrency Question

  Hi, I've written the following stored procedure: BEGIN TRANSACTION SELECT * FROM UserStats WHERE U…

  Jamie Julius

  92 replies

  17 years ago

  By: Lynn Pettis