T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Deleting huge number of Records

  Dear Experts, I have a requirement to purge a table which is holding 5 millions of records. Can you…

  mohan.pariveda 18256

  9 replies

  14 years, 2 months ago

  By: mohan.pariveda 18256

• Why do these similar queries run at such a different speed?

  This one is bugging me. I cant figure out why one query runs extremly slow while the other is fast …

  erikpoker

  24 replies

  14 years, 2 months ago

  By: erikpoker

• Warning: Null value is eliminated by an aggregate or other SET operation.

  When I try to execute the below query, I get the warning Warning: Null value is eliminated by an ag…

  sreesang

  4 replies

  14 years, 2 months ago

  By: sreesang

• Help with a query

  Im having trouble getting specific recordset... I have two tables. #user and #work A user can have …

  memymasta

  2 replies

  14 years, 2 months ago

  By: memymasta

• Max Query Cost per User?

  I know you can set it at a server level but does anyone know if it is possible to restrict certain …

  aaa121

  6 replies

  14 years, 2 months ago

  By: Paul White

• Help in Updating an exception table

  Hi all, I have to write SP to update an exception table. The problem is while a new record comes in…

  prasadau2006

  7 replies

  14 years, 2 months ago

  By: prasadau2006

• Recode existing data to hide information but provide the same patern

  Hi, I have a table called tblInvoices where any the letters represent the same value, for example l…

  adrian.buzgau

  4 replies

  14 years, 2 months ago

  By: adrian.buzgau

• Store procedure header

  We are creating header for each strored procedure with below details.. -- =========================…

  gugan_ta

  6 replies

  14 years, 2 months ago

  By: mtassin

• PIVOT Statement

  I am trying to turn a table that looks like this: Year Cost Price 2009 10 100 2010 20 …

  hkflight

  3 replies

  14 years, 2 months ago

  By: Jason Selburg

• Copies row into the same table if not exists

  I have a query like below, I would like to INSERT INTO orgAllocationJobCode ( JobCode, Allocatio…

  sqlfriend

  4 replies

  14 years, 2 months ago

  By: sqlfriend

• problem using left join - not showing all possible results

  hello all, i am trying to cross the results of two tables and its driving me nuts for some time. ED…

  a20213

  13 replies

  14 years, 2 months ago

  By: jcb

• Calendar table, Equinox/Solstice & Astronomy calculations

  I am building a calendar table, and would like to be able to add astronomy calculations to it (or t…

  Steve_o

  6 replies

  14 years, 2 months ago

  By: SQLRNNR

• insert multiple rows with a trigger that invoke a function

  Hello, I need some help with the following problem Multiple rows to insert: --------------------- i…

  all023

  14 replies

  14 years, 2 months ago

  By: TheSQLGuru

• Calculating Year to Date total

  I have the following two table definitions. The query I have here is sort of what I need to display…

  chrisvolny

  5 replies

  14 years, 2 months ago

  By: Jeff Moden

• alternative to table variable and temp tables

  Thank you in advance I need to reserve memory and keep performance the best I am using declare @myt…

  Sarsoura

  3 replies

  14 years, 2 months ago

  By: Ron McCullough