T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• How to insert data into table without cursor

  Hi: I've a stored procdure which inserting data from one table to another table in my db. I use cur…

  h_maksuda

  4 replies

  16 years, 4 months ago

  By: h_maksuda

• Trying to avoid an cluster index scan and use best practices for application code

  CREATE PROCEDURE [dbo].[p_getCallStats] @Col1 int = null, @col2 datetime = NULL, @col3 int = NUL…

  NewbieCoding

  3 replies

  16 years, 4 months ago

  By: Gail Shaw

• Recursive Querry to get all Childs

  Hi , I have a table which has parent child relation ship. I need to build a stored procedure which…

  descentflower

  3 replies

  16 years, 4 months ago

  By: Lynn Pettis

• Simple Query

  I have check No. of objects (stored procedures, views or functions) that each table is using in suc…

  Shamshad Ali

  1 replies

  16 years, 4 months ago

  By: Shamshad Ali

• Should use XML indexes or not?

  I'm using XML datatype column in one of my table which has following structure …

  Bhavesh-1094084

  2 replies

  16 years, 4 months ago

  By: Bhavesh-1094084

• NewBie Help - Group by

  I have a table with 10 customergroups and their sales for one year: CustomergroupName Salesfigures …

  Søren

  3 replies

  16 years, 4 months ago

  By: Allister Reid

• SQL w/ MAX function does not work

  /* This SQL will not execute unless I comment the SELECT MAX FUNCTION below: */SELECT DISTINCT RTR…

  Express12

  8 replies

  16 years, 4 months ago

  By: Express12

• Execution Plan seems to use wrong where indication

  Hi everybody, I've been reading here quite a lot but now I also have a problem which I can't seem t…

  stephan.koeppen

  2 replies

  16 years, 4 months ago

  By: stephan.koeppen

• PIVOT problem : produces multiple lines

  I'm trying to use the PIVOT function CREATE TABLE #tblResults ( [Id] [int] IDENTITY(1,1) NOT NULL…

  alef

  9 replies

  16 years, 4 months ago

  By: Lynn Pettis

• find users that only have certain value

  I am trying to find a way to get results of ids that only have a value of z and no other value. The…

  Robert Klimes

  5 replies

  16 years, 4 months ago

  By: Robert Klimes

• A script I was working on. Your thoughts and opinions?

  Hello all, So I was bored and felt like throwing some script together. I wanted to see if I could …

  shannonjk

  19 replies

  16 years, 4 months ago

  By: shannonjk

• Need a Line Seperator Between Data

  Hi Folks I am trying toi find a way to add a blank line between like data. Is there a way in T-SQL?…

  JC-3113

  9 replies

  16 years, 4 months ago

  By: JC-3113

• Distinct going slower than *

  ......New problem query posted on page 4..... Link -> http://www.sqlservercentral.com/Forums/Fin…

  Putts

  57 replies

  16 years, 4 months ago

  By: Putts

• Different results using CONTAINS and LIKE

  Hi, create table Testtable ( ID INT NOT NULL IDENTITY, ColumnName varchar(max), CONSTRAINT [PK_Col…

  sudhanva

  5 replies

  16 years, 4 months ago

  By: Mauve

• Concatenate nvarchar variables

  SQL 2005 I have a table with the following fields: Segment1 (nvarchar(50), null) Segment2 (nvarchar…

  lnelson

  2 replies

  16 years, 4 months ago

  By: lnelson