T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• "Ambiguous column name" error in one environment, not the other.

  I am getting the "Ambiguous column name" error on a simple query on one table in our PROD environme…

  reefshark

  13 replies

  10 years, 4 months ago

  By: Lynn Pettis

• UPDATE from CTE

  Hi. I have a CTE that returns 2 cost values. WITH UpdateAverageLabourCost (ProductId,OH,Labour) AS…

  2Tall

  22 replies

  10 years, 4 months ago

  By: rawatfet90

• Find any character that isn't a number or letter - confused!

  I am struggling with what should be a simple issue....I want to search a postcode field (varchar co…

  rarara

  11 replies

  10 years, 4 months ago

  By: Alvin Ramard

• Try/Catch within a trigger to supress errors

  I realize that triggers are implicit transactions and any error dooms the transaction but why can't…

  Chris Gierlack

  1 replies

  10 years, 5 months ago

  By: Mr.Sahand

• UNION ALL performance issues - one table is NULL

  We have a table structure with current data in one DB / table and archived data to be moved to anot…

  nblenkush

  1 replies

  10 years, 5 months ago

  By: Alan Burstein

• Not readable SQL code that writes XML output

  Our code that writes XML output is very hard to read. It is using FOR XML PATH('XXX-XXX'), TYPE ) m…

  RVO

  1 replies

  10 years, 5 months ago

  By: drew.allen

• Numeric/Negative Check

  i Have a table with a column Capacity which is char(10) and gets populated from user files. I want …

  Naina_11

  5 replies

  10 years, 5 months ago

  By: Luis Cazares

• Stored Procedure error when changing compatibility mode to 90 (2005)

  I am testing in anticipation of changing our sql compatibility mode from 80 to 90. I have a stored …

  jlwile

  5 replies

  10 years, 5 months ago

  By: Luis Cazares

• Delete records older than 90 days in SQL Server

  I would like to delete records from all tables which is older than 90 days. I know that stored proc…

  kbadarinath

  9 replies

  10 years, 5 months ago

  By: Steve Jones - SSC Editor

• Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0.

  Hello, is there any way to have sqlserver to terminate the current batch when that situation is det…

  allarmi

  1 replies

  10 years, 5 months ago

  By: Phil Parkin

• Delete Records older than 90 days

  I have two tables one contains @300 millions records & the other contains @ 500 millions of re…

  div4u22

  4 replies

  10 years, 5 months ago

  By: Brandie Tarvin

• Why use Select 1

  IF EXISTS (SELECT 1 FROM sys.indexes WHERE name = 'Index name here' AND object_id = OBJECT_ID('Tabl…

  Mike Aguilar

  4 replies

  10 years, 5 months ago

  By: Jacob Wilkins

• Specifying [TAB] as SQLCmd Column Separator

  BOL says "The column separator can be any 8-bit character." I have tried the BCP "\t" symbol, as w…

  PhilPacha

  5 replies

  10 years, 5 months ago

  By: mstjean

• Group rows and convert to columns

  Hi, I want to convert the rows and group into fixed columns format. Could you help me? This is my t…

  daven168

  2 replies

  10 years, 5 months ago

  By: daven168

• Get Prior Max of Quantity

  create table #try(id int,sourceno int,destno int,quantity int) insert into #try values(1, 100,nu…

  sreeram.sivakumar 61990

  11 replies

  10 years, 5 months ago

  By: Umer Akram