T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Dead Lock Help..

  Hi All, I need big favor, Here is my question, I am getting dead lock error. When I try to insert …

  rocky_498

  4 replies

  11 years, 11 months ago

  By: Gail Shaw

• Inner Cursor Error

  Hello, I have been using dynamic sql in an inner cursor and I get an error about the fetched variab…

  Kuzey

  8 replies

  11 years, 11 months ago

  By: Luis Cazares

• Force RaiseError for selected sysmessages

  Not a very succint title, wan't sure how to put it ... basically, our monitoring team are putting t…

  N.D

  8 replies

  11 years, 11 months ago

  By: DBANewbie

• Comparing Various Currencies Hedged Rates

  I have a task to provide users with a list of currency rates in the following format: Base Currency…

  BOR15K

  3 replies

  11 years, 11 months ago

  By: J Livingston SQL

• Advise on how to add counts to a query

  Need assistance working out how to get task counts in a sales report. The data is located in three …

  TK-484813

  4 replies

  11 years, 11 months ago

  By: ScottPletcher

• Using Union ALL or Union kills performance on a stored proc

  Hi All, SQL Server 2008 r2... I have a query which does 3 selects and Union ALLs each to get a fina…

  Charlottecb

  4 replies

  11 years, 11 months ago

  By: ScottPletcher

• Replace a special charecter in results

  All, First time post and I am learning TSQL. Anyway, I have a weird issue that I was hoping you gu…

  daflake

  2 replies

  11 years, 11 months ago

  By: daflake

• Selecting from a remote spreadsheet

  Hi all, I'm trying to run this code, which worked on SQL 2000, on 2K8: SELECT [Business Unit] …

  Jake Shelton

  2 replies

  11 years, 11 months ago

  By: Jake Shelton

• exec sp_getapplock - Different behaviour using go or without go

  Hi everybody, we have a strange behaviour while using sp_getapplock (we tried to use this to solve …

  l.romanato

  1 replies

  11 years, 11 months ago

  By: l.romanato

• Arithmetic overflow error converting numeric to data type numeric

  when I run below query I got Error of Arithmetic overflow error converting numeric to data type num…

  azhar.iqbal499

  2 replies

  11 years, 11 months ago

  By: Luis Cazares

• dynamic pivot issue

  Hi I am trying to pivot data based on columns value in year column... but results are not showing u…

  sql_learner29

  5 replies

  11 years, 11 months ago

  By: sql_learner29

• Date comparison in two table by returning the nearest date of table A in table B

  Hi, I am having a problem in creating query for this exciting scenario. Table A ID ItemQtyC…

  arnold-491793

  3 replies

  11 years, 11 months ago

  By: VIG

• Help with Query

  Please note that I am using Sybase ASE Consider the following sample data: IF OBJECT_ID('dbo.nfg25…

  Abu Dina

  7 replies

  11 years, 11 months ago

  By: J Livingston SQL

• Problem with generating XML in MS SQL

  Hi All, I m facing a prblm in generating the XML. Please help me guys. My Current Output : <Ro…

  subbubally

  3 replies

  11 years, 11 months ago

  By: Cadavre

• Capture Database Sizes Table with Date

  I'm trying to capture the sizes of all Databases into a Permanent Table and include the Date. It wo…

  Welsh Corgi

  9 replies

  11 years, 11 months ago

  By: delizat