T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Performance tuning tips for beginners

  I want to know what do you guys(sql server experts) do when you are asked to tune a stored procedur…

  deepikamm

  10 replies

  15 years, 5 months ago

  By: Gail Shaw

• Case statement

  select (CASE WHEN @ReportParameter1='apple' THEN (select DESCRIPTION from CIRC.TAG Where Rownum &…

  varunkum

  3 replies

  15 years, 5 months ago

  By: varunkum

• SELECT Highest Combination of Fields

  Hi I am trying to select the row with the highest combination of values and cant figure out how to …

  Mike__U

  10 replies

  15 years, 5 months ago

  By: Mike__U

• To start sql output frm the middle of the page

  Hi, I have a sql query ########################### selectcount(tot_files) (title 'Number of files…

  gnaneshs

  8 replies

  15 years, 5 months ago

  By: Jeff Moden

• Table variable vs Temp table for approx 50000 records?

  I am trying to decide whether to use temp table or table variable in stored procedure. Based requir…

  akhandels

  12 replies

  15 years, 5 months ago

  By: Elliott Whitlow

• Dynamic Column names based on value in other table.

  Hi, I wanted to assign the column names for a particular view of which the column names are in a d…

  JackIntheBox

  11 replies

  15 years, 5 months ago

  By: Evil Kraig F

• Dump table to email

  Hi I want to dump the result of a select into a email to send as is. Query is: SELECT DET.orderIt…

  Dominic Gagné

  4 replies

  15 years, 5 months ago

  By: Dominic Gagné

• Query Performance Tuning

  Hi All, I would like to get some help regarding optimizing the below query. Is there anything very …

  akhandels

  8 replies

  15 years, 5 months ago

  By: akhandels

• Doubt clarification

  i want to know the exact diference between table scan and index scan.i read about 6 to 7 articles b…

  deepikamm

  22 replies

  15 years, 5 months ago

  By: deepikamm

• Find consecutive in a set

  Hi there, I have a table called TradeView: CREATE TABLE [dbo].[tradeView]( [tradeId] [int] NOT NUL…

  keymoo

  2 replies

  15 years, 5 months ago

  By: WayneS

• sp_executesql

  what is the major difference between EXEC and sp_executesql?

  deepikamm

  15 replies

  15 years, 5 months ago

  By: Grant Fritchey

• Call to SP with exec from another SP stopped working

  Hello everyone, I have a SP called p_ins_support_call, which, inside it, has an exec statement to a…

  marcelo.magri

  1 replies

  15 years, 5 months ago

  By: Lars Søe Mikkelsen

• what is select 'X'?

  can anyone explain me the functionality of "select x from tablename"?

  deepikamm

  11 replies

  15 years, 5 months ago

  By: deepikamm

• First time semi-complex query - its slow!!!

  Ok so I am giving myself a huge pat on the shoulder because i've had no formal training on SQL nor …

  ProKelly

  25 replies

  15 years, 5 months ago

  By: Jeff Moden

• select pattern from the column name

  i want to read '_1_ ' or '_2_' from the "file" column in the table as shown #######################…

  gnaneshs

  6 replies

  15 years, 5 months ago

  By: Sean Lange