T-SQL

• Topics

  Started by

  Posts

  Last post

• While/If conditionals neither true nor false when using "EXISTS"

  This started as a WHILE loop and then I switched to IF to see if it made any difference.  I do…

  Doug Perlich

  5 replies

  19 years ago

  By: Lynn Pettis

• Advanced query possible UNION ? help

  Hello, I am attempting to use a find the number of points between two points. I have 3 tables that…

  Swindla

  9 replies

  19 years ago

  By: Swindla

• Restore backup Problem

  Hi, I want to restore backup from a backup file which is kept in a computer which is …

  Vijay Soni

  4 replies

  19 years ago

  By: Gift Peddie

• Is there any method to reset the Identity value other than the DBCC CHECKIDENT command

  Hi, I have a requirement to reset the identity column of a table , but the user doing this will not…

  Rajesh K Chandran

  5 replies

  19 years ago

  By: Steve Jones - SSC Editor

• case when problem in query

  I'm trying to evaluate several columns and have the answer populate a single column: case…

  Jeff-132889

  6 replies

  19 years ago

  By: kiruba-370649

• Select from all databases across multiple servers

   Hey Guys: I am pretty new to sql. I need help please. I have several client databases across …

  Ghanta

  1 replies

  19 years ago

  By: Ghanta

• unique constraint on col & allow more than 1 null

  I created a unique constraint on a column called Col1 in table Test1 to enforce uniqueness with the…

  satnam sarai

  4 replies

  19 years ago

  By: noeld

• Converting 1 Address line to two without messing up address line

  I need help taking an address field that is 50 characters and need to split it into two fields of 2…

  CF-156768

  6 replies

  19 years ago

  By: CF-156768

• divide by zero, but no fields are zero

  Hi, I am trying to fix a problem in a  T-sql procedure I'm getting a 'divide by zero error' i…

  Steven vermeulen

  10 replies

  19 years ago

  By: Sergiy

• TSQL Faster Than Stored Procedure?

  SQL 2000, SP3A. I set up a view into our HR database for another app to query employee information.…

  Chris Stamey

  28 replies

  19 years ago

  By: jezemine

• Trigger for update and insert with select condition

  Hi, I have a table below Table A ID ModDate InputDate Type 1 12/1/05 12/3/05 2 2 1/13/06 1/30/06 5…

  pcq0125

  3 replies

  19 years ago

  By: pcq0125

• Is it possible to format a COMPUTE clause?

  Hello everyone, When our financial data warehouse gets out of balance, we rebuild the month that is…

  Scott Herrmann

  4 replies

  19 years ago

  By: Scott Herrmann

• How do I change the "sign" of a number in a case statement ?

  Hi, the values created in my view by this select statement carry through negative numbers as "Scrap…

  Craig Lloyd

  7 replies

  19 years ago

  By: John Mitchell-245523

• Help - How to build this query

  Hello everyone I am a bit new here, but hopefully you can help me. First I shall provide a listing …

  David larrabee

  15 replies

  19 years ago

  By: David larrabee

• Databasae is in Suspect Mode.

  Hi,   Presently i am using sql server 2000 and the service pack is sp3a. Today i have found on…

  Bagath

  1 replies

  19 years ago

  By: Camilo Torres