T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Find Similar rows and add totals together.

  Hello all, I have a question and just cant figure it out. For example I have a table with 5 columns…

  leroy-1092048

  12 replies

  15 years ago

  By: ChrisM@Work

• Unknown Error When Comparing Values In Stored Procedure

  Hi All, I have a stored procedure, which I'm calling from ASP.Net application. I'm facing a problem…

  linkaddy

  2 replies

  15 years ago

  By: linkaddy

• Deletes in a transaaction

  Hi all I recently wrote a transaction using @@error to check that there was no errors before commit…

  Kwisatz78

  3 replies

  15 years ago

  By: Kwisatz78

• Results to merge customer names

  Hi I have a SSRS report which is working but I want to merge some customers together e.g. Select Cu…

  iwatson

  3 replies

  15 years ago

  By: Evil Kraig F

• query

  Is there an alternate way to query this to make it fast. insert into dbo.emp_A (Column1,Column2,Co…

  Tara-1044200

  1 replies

  15 years ago

  By: WayneS

• Case Statement Error

  I am getting the following error: Msg 156, Level 15, State 1, Line 9 Incorrect syntax near the key…

  Cheryl McLaughlin-385812

  5 replies

  15 years ago

  By: Cheryl McLaughlin-385812

• create View using PARTITION BY

  I have two tables in my view, tblAttorney and tblCaseParty. Each Attorney has a CaseNumber, CasePar…

  esilva002

  3 replies

  15 years ago

  By: esilva002

• How to create procedure from definition of another procedure

  Hello everyone!!! I need help to create procedure from definition of another procedure(may be from …

  roman.goldenberg

  12 replies

  15 years ago

  By: roman.goldenberg

• Identify if a record exists on a table

  I have two tables (PmtTrn & AdjTrn). Both of these table a column called Itrn. Basically, if t…

  JStevenson1

  3 replies

  15 years ago

  By: sharath.chalamgari

• TSQL giving ADO Error

  Hello, I am trying to figure out what is wrong with this code. I have a ms sql 2005 as my database…

  jsucupira

  8 replies

  15 years ago

  By: jsucupira

• SQLSERVER TRiggers

  I have a table,if 2 of its columns r updated , the 3rd column should return a null value. can any o…

  padmapatibandla-858284

  7 replies

  15 years ago

  By: GSquared

• ODD SQL Behavior

  Can somebody tell me why the SQL below is not behaving as expected? Is this another SQL quirk or i…

  David Paskiet

  11 replies

  15 years ago

  By: scott.pletcher

• Dynamic Sql QUERY To use Dynamic openrowset

  Hi All, i have 20 servers. each server contain store proc named as sp_dbdetails. From all servers…

  syamala.popuri

  3 replies

  15 years ago

  By: sjimmo

• Error in Dynamic open row set query

  declare @server as varchar(50) SELECT @server = RTrim(ServerName) FROM master.dbo.ServerList1 WIT…

  syamala.popuri

  1 replies

  15 years ago

  By: Gail Shaw

• get the name of the bit column set to 1

  Hello In a table I have 10 bit columns and I know only one of the 10 will be to 1, the 9 others wil…

  dubem1-878067

  4 replies

  15 years, 1 months ago

  By: scott.pletcher