T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• How to capture the old version of an SP, View or Function in a DDL trigger

  Hi, Just wondering if you can capture the old version of an object inside a DDL trigger? I've trie…

  Roust_m

  2 replies

  16 years ago

  By: daxz

• Updating tables in Linked server

  I have a scenario where i need to update a table (thru linked servers) based on the temporary table…

  sugaz007

  1 replies

  16 years ago

  By: Oleg Netchaev

• Using a column value for the decimal scale value

  I have a column in a table called DecimalPrecision and the datatype is int. I am trying to use the…

  Laurie N Lemons

  3 replies

  16 years ago

  By: Mike01

• error handling

  I am executing a store proc in a sql job and would like to send an email on successfull/failure exe…

  Tara-1044200

  7 replies

  16 years ago

  By: Tara-1044200

• Old SQL Code That Won't Run in SQL 2005

  We have a trigger that no longer runs in SQL 2005 after migrating from SQL 2000. I know it is beca…

  Roger Abram

  3 replies

  16 years ago

  By: WayneS

• How to group consecutive months

  I have a table with the following data account_numberpayment_amtDATE_PAYMENT_DUEnum 10043997379…

  NewbieCoding

  5 replies

  16 years ago

  By: NewbieCoding

• Help to optimize inner join

  Hi all I have a query of the following form. SELECT a.Col1, b.Col2 FROM aTable a INNER JOIN vTable …

  Anders Hansen

  6 replies

  16 years ago

  By: Anders Hansen

• SQL Server: How do I ignore errors on a view creation?

  I have a sql script which creates a view. This view references a table that does not exist when th…

  Joseph_Schrag

  2 replies

  16 years ago

  By: Joseph_Schrag

• Combining INSERT And UPDATE Triggers?

  Hi, I have a table: CREATE TABLE Blah ( Pid INT, CreatedUserID VARCHAR(50), CreatedDate DATETIME, M…

  dajonx

  3 replies

  16 years ago

  By: LutzM

• Only return records where all sub records match

  I am rewriting the delivery / postage section of an e-commerce website and for part of it we need t…

  cdh-727733

  3 replies

  16 years ago

  By: cdh-727733

• Multiple Try Catch Blocks

  Hello, In development or in debugging I try to identify what went wrong and return messages that ar…

  nfs_john

  6 replies

  16 years ago

  By: Eugene Elutin

• Question about "Execute as "

  Hi folks, I am wondering if it is possible to execute a sp or fn on a linked server with a read-acc…

  halifaxdal

  8 replies

  16 years ago

  By: Marco

• Common Table Expressions overuse

  I'm seeing a lot of code like ; with EMP_CTE(EMPID, NAME) AS (SELECT EMPID, NAME FROM EMPLOYEE WHE…

  Ion Freeman

  3 replies

  16 years ago

  By: Jeff Moden

• Return Dynamic SQL Results to a Table

  Hi, I have an unusal query which I am looking more for general advice than specific code. I have a …

  RTaylor2208

  2 replies

  16 years ago

  By: RTaylor2208

• Query hierarchical data

  hi, i have a table storing the contact groups for my addressbook application. groups can be nested …

  liuc

  3 replies

  16 years ago

  By: kramaswamy