T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• valiate each parent intermediary is also a parent to itself

  I have a table for which I want to validate where each parent intermediary is also a parent to itse…

  manoj.ramaiah

  1 replies

  13 years ago

  By: Steve Jones - SSC Editor

• Trigger effect

  Hi, I have a scenario... I have a table Table1 with columns ID, Names, WorkLocation I have created …

  kapil_kk

  5 replies

  13 years ago

  By: Gail Shaw

• facing problem in configration of database

  Hey! I have been using my local database for dev Purpose . Now i m trying to connect my application…

  hafsahafeez91

  4 replies

  13 years ago

  By: Eugene Elutin

• Join creating two records

  I have a join that is doing something that I can not explain. I have two tables.. linking on Delive…

  dwilliscp

  14 replies

  13 years ago

  By: dwilliscp

• Simple derived table with multiple rows

  I'm having trouble creating a simple derived table. It is so simple to create a derived table with …

  memymasta

  4 replies

  13 years ago

  By: memymasta

• update MySQL from SQL Server

  Hi All, I have managed to set up a linked server to a MySQL database and i want to update the MySQL…

  martin.kerr 34088

  1 replies

  13 years ago

  By: Lowell

• Performance Tuning

  Hi, I am working on tuning an sp . I tried to remove the cursor and get the values in a temp table…

  PSB

  1 replies

  13 years ago

  By: Eugene Elutin

• Add 20 before regular expr (year)

  Hi All, I am getting input file below format. Text-dd.mm.yy. i need to display as 20yy (year) and m…

  rohit.kumar.barik

  3 replies

  13 years ago

  By: ChrisM@Work

• Writing to local variable from CTE

  Can I write to a local variable from inside a CTE? I am trying to get a comma delimited string of m…

  tshad

  14 replies

  13 years ago

  By: Lynn Pettis

• Whats wrong with it, Transaction mismatch.. Please help.

  IF OBJECT_ID('test_parent_table') IS NOT NULL DROP TABLE test_parent_table CREATE TABLE test_parent…

  Ashok Teotia

  1 replies

  13 years ago

  By: Ashok Teotia

• How can I get the dates I need?

  date1 >= 01/01/2013 --@STARTDATE date1 <= 02/28/2013 --@ENDDATE columns: quote# date…

  rick.servant

  2 replies

  13 years ago

  By: Lynn Pettis

• CROSS APPLY Question

  Hello All, I had a request to concatenate the various entries of a specific column into one row per…

  Ronnie Jones

  3 replies

  13 years ago

  By: Ronnie Jones

• Stubborn FK doesn't want to play nicely during insert statement

  Stupid Troublesome Error Code: The INSERT statement conflicted with the FOREIGN KEY SAME TABLE cons…

  SQL_Enthusiast

  6 replies

  13 years ago

  By: Lynn Pettis

• Recursive SQL

  Hi All, Need help on some recursive Data. I would need to get 4 records out of below available If I…

  syedathariqbal

  7 replies

  13 years ago

  By: Jeff Moden

• IS NULL in a Case Statement

  This is probably very simple but I can't get it to work. If trying to write this Case Oppo_stage Wh…

  ssmith 29602

  9 replies

  13 years ago

  By: Orlando Colamatteo