T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Dynamic SQL

  Hello, Upon executing the following code I get this error: ----------------------------------------…

  Beginner2012

  5 replies

  13 years ago

  By: Jeff Moden

• Subtract Value At Previous Row From Current Row

  Hi Can someone please help me with this? Raw Data ID StartDate DEP EndDate 1 14/02/2011 A 14/…

  HUSRAF

  9 replies

  13 years ago

  By: ChrisM@Work

• Using Union..but that's wrong..is there an un-union?

  I have two statements (below) that do two different things.--With Terminations SELECT ----DATEPART(…

  krypto69

  8 replies

  13 years ago

  By: Jeff Moden

• Is this possible?

  Is it possible to have this query do a distinct count of each orglevel? SELECT ----DATEPART(YEAR, …

  krypto69

  4 replies

  13 years ago

  By: MVDBA (Mike Vessey)

• Leading Zeros in Varchar Column

  Hi, I wonder if anyone can explain the following: I have a table that has a column [unique_name] de…

  tbraithwaite

  11 replies

  13 years ago

  By: tbraithwaite

• Compare Two Row in the table and find what columns are changed

  Hi, i have a table like below Create Table tab1 ( RefNo varchar(10), Version int, details varc…

  sharath.chalamgari

  13 replies

  13 years ago

  By: Sultan-741183

• Modify the output

  I already have the sp written but it is really ugly, I want to rewrite it, can anyone help? I have …

  halifaxdal

  7 replies

  13 years ago

  By: halifaxdal

• XML Node Query

  Hello, I was given a task to have a query which gets the information from the xml data in a table f…

  lucky-80472

  5 replies

  13 years ago

  By: yghwang

• call executable with xp_cmdshell from procedure

  The following indicates that xp_cmdshell works like expected: declare @sqlcmd varchar(200) SET @sql…

  blom0344

  3 replies

  13 years ago

  By: blom0344

• only importing one row at a time with sql loader statement

  LOAD DATA LOCAL INFILE 'C:\\Documents and Settings\\J03299\\Desktop\\TMETER.csv' INTO TABLE edata C…

  poagola

  2 replies

  13 years ago

  By: Eugene Elutin

• Store Procedure is not getting executed via application but executes in SSMS

  Hi, i am finding an issue where in if we take the profiler data and executes in SSMS the SP execute…

  dakshinamurthy-655138

  4 replies

  13 years ago

  By: dakshinamurthy-655138

• View with Parameter??

  Can you use a variable with a view? I have a view that joins 5 tables, one of which is an OpenQuery…

  Ken at work

  8 replies

  13 years ago

  By: Ken at work

• Compare Data between two table

  hi i need script or function or procedure to get field's name has data difference and get this data…

  mohamed_sobhy565

  2 replies

  13 years ago

  By: mohamed_sobhy565

• Deleting records without transaction log

  I see that this topic has generated a lot of discussion. I am also in a situation where I want to d…

  mcopciac

  2 replies

  13 years ago

  By: Steve Jones - SSC Editor

• Help with Unpivot (or similar)

  Hi all I have a table that holds order details in columns. eg. OrderNo, Prod1, Prod2, Prod3........…

  Steve007

  2 replies

  13 years ago

  By: Steve007