T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• update query error

  I am writing the following update query which is giving me an error saying more than 1 records retu…

  newbie_sql

  2 replies

  16 years, 3 months ago

  By: ChrisM@Work

• Allow other users to run SELECT while TRANSACTION is being run by one user

  Assume that a user U1 is running a transaction on a table T1. While the transaction is in process a…

  khatri03

  1 replies

  16 years, 3 months ago

  By: Pavel Pawlowski

• trigger on a row level

  Hi, I have a tbl: USE [Sergei_SandBox] GO /****** Object: Table [dbo].[test_2] Script Date: 03/…

  Sergei Zarembo

  18 replies

  16 years, 3 months ago

  By: Paul White-150008

• Update Last Row Value NOT NULL

  Hi All, How do I update the Live temp table using the Maint table with the last row values that is …

  James Tech

  8 replies

  16 years, 3 months ago

  By: Johan Bijnens

• Identify the row / value that caused a conversion / out-of-range error?

  Hello board Often, when I try to import old date from a table, where the date is stored as varchar …

  pesche_h

  10 replies

  16 years, 3 months ago

  By: Garadin

• Is there a way for a sproc to give control back to calling application while finishing executing?

  I've got a long running sproc. Would like to return a 0 to the calling application right off the b…

  Greg J

  2 replies

  16 years, 3 months ago

  By: Greg J

• Generate XML Tree Structure

  I want to form an XML document something like below in order to send this data to frontend( .net) t…

  amalanto

  3 replies

  16 years, 3 months ago

  By: LutzM

• Need to Write a query for aggreagtion

  create table #x (phno int, Description varchar(20), qty int, amt money, type varchar(30)) insert in…

  Chinna

  3 replies

  16 years, 3 months ago

  By: Steve Jones - SSC Editor

• Recursive CTE comma list parser

  I recently had to import data from a third party system that had (ugh) comma separated fields in a …

  Jay_Noob

  5 replies

  16 years, 3 months ago

  By: Lynn Pettis

• need to write sp to move stored procedures from development server to production server .

  plz help me

  nikki123

  1 replies

  16 years, 3 months ago

  By: ColdCoffee

• n.value = isNull(@Value,n.Value) Different Record Counts Returned.

  We use IsNull in the where clause to dynamically change our returned values. This isn't anything n…

  bbrickey-876561

  4 replies

  16 years, 3 months ago

  By: Timothy J Hartford

• Summing An Aggregated Column

  How do I sum the derived column, Theo_Gains for the day if I already used Sum() to calculate the T…

  ackrite55

  3 replies

  16 years, 3 months ago

  By: Timothy J Hartford

• Using Multiple Select Statements in an Insert Statement

  Does anyone know of a way to use multiple select statements in one insert statement? For example: i…

  sync

  10 replies

  16 years, 3 months ago

  By: RBarryYoung

• A few records in a single row

  I need a help. I don't know who function i got to use. I have the sample structure Table client – i…

  midelima

  2 replies

  16 years, 3 months ago

  By: Jack Corbett

• how to flag duplicate records but diff quantity

  create table #x (phno int, Description varchar(20), qty int, amt money) insert into #x values(123,'…

  Chinna

  7 replies

  16 years, 3 months ago

  By: Chinna