T-SQL

• Topics

  Started by

  Posts

  Last post

• Syntax Help Needed

  Hello, I am trying to set up a Stored Procedure that will evaluate the value of a Bit type field ca…

  cdun2

  4 replies

  23 years ago

  By: cdun2

• Stored Procedure and ')' error

  SQL2K, ColdFusion 5.0 on Win2k IIS 5.0 When I run this from Query Analyzer, it works great. When I …

  msuemnig

  3 replies

  23 years ago

  By: msuemnig

• Stripping a string

  I have a field that contains data in this format: 'souph-0-97' What I need to do is bring back just…

  cedar72

  3 replies

  23 years ago

  By: cedar72

• SQL Server (dis)Functions

  So, all I wanted to do was create a Function (in-line/scalar or table - doesn't really matter to me…

  joshcsmith13

  7 replies

  23 years ago

  By: joshcsmith13

• Count WeekDays

  I would like to create a SQL statement(s) that count up the number of weekdays in a certain date ra…

  Matthew-12035

  4 replies

  23 years ago

  By: cql

• system stored procedure

  Does anyone know what this system SP does: sp_MS_marksystemobject How do you use it? Thanks

  eletuw

  2 replies

  23 years ago

  By: eletuw

• No parameters and arguments were supplied

  The story: There is a table with a trigger on it. The trigger calls a stored procedure. The stored …

  Botond

  7 replies

  23 years ago

  By: Hans Lindgren

• Strange sql results

  My select statement: SELECT DISTINCT CM.ID,NAME1,PHONE,CITY,STATE,QUALIFIED_EQUIP,INSURANCE_EXP,INS…

  matt101

  3 replies

  23 years ago

  By: Hans Lindgren

• Error Handling

  Hi people, Having trouble with my error handling. I have If(@@Error <> 0) Goto ErrorHandle In…

  The ScareCrow

  11 replies

  23 years ago

  By: paulbowman

• NOT IN Problem

  Hi! I need a query like this, with one restriction: I can't have a condition in the subquery. I hav…

  migol

  5 replies

  23 years ago

  By: bsluman

• problem decimal* real

  i have big problem. i have a view with decimal * real. ex: 10.....076 * 1 = 10.....080 how can i s…

  costica

  1 replies

  23 years ago

  By: msalomon

• Sql Server Challenge -- can it be done?

  I wrote a VB algorithm to do the following task but I wonder if it could be done in t-sql (I don't …

  Barkingdog

  4 replies

  23 years ago

  By: Greg Larsen

• Update query problem

  Hi: I'm having difficulty with a query that takes much longer than I think it should, but maybe no…

  John King

  1 replies

  23 years ago

  By: Botond

• Insert without logging.

  Does anyone know how to process inserts or updates in a stored procedure without creating a transac…

  andrew.zecha@hubx.net

  1 replies

  23 years ago

  By: Allen Cui-55137

• Fetched Result order if no ORDER BY clause

  Hello, here's an interesting story that might make you laugh...followed by a quick question: A juni…

  BrendonSmith

  2 replies

  23 years ago

  By: Jeremy Kemp