T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Querying from two databases

  My query pulls data from two separate databases, and it runs extremely slow. The queries run well w…

  seequill

  9 replies

  11 years, 9 months ago

  By: ScottPletcher

• Paging Data Doesn't Work

  Hi This my stored procedure ALTER PROCEDURE [dbo].[PageWise] @PageIndex INT = 1 ,@Page…

  Hrhb.mail

  8 replies

  11 years, 9 months ago

  By: Sean Lange

• Is there a way to do this without dynamic sql?

  select Queue.ScheduledTaskQueueId QueueId, Queue.QueueMaximumLength, Queue.IsLargeQueue…

  TheGreenShepherd

  19 replies

  11 years, 9 months ago

  By: Sachin Nandanwar

• 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, 9 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, 9 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, 9 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, 9 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, 9 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, 9 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, 9 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, 9 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, 9 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, 9 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, 9 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, 9 months ago

  By: VIG