T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Optimizing Stored Procedures that utilize only local variables (and lots of them)

  Our proprietary reporting module calls stored procedures that have no parameters but make extensive…

  jshahan

  16 replies

  13 years, 10 months ago

  By: mtassin

• T-SQL String manipulation - 2(Reading numeric values from String appended by '.')

  Hi, I have to peform a string manipulation as below: String manipulation shoud effect only the numb…

  ssskumar4u

  10 replies

  13 years, 10 months ago

  By: Phil Parkin

• T-SQL String Manipulation- Need help

  Hi, I have to manipulate string as below: ( integers placed in brackets should be replaced by n) S…

  ssskumar4u

  14 replies

  13 years, 10 months ago

  By: ChrisM@Work

• Urgent request please

  if i have records as follows: ID Status 1 0 2 1 3 0 4 1 5 1 6 1 7 …

  ramadesai108

  9 replies

  13 years, 10 months ago

  By: ramadesai108

• trace question

  Is there a way to save a sql server 2008 trace as a sql statement?

  BaldingLoopMan

  5 replies

  13 years, 10 months ago

  By: Steve Jones - SSC Editor

• Bulk insert slower after upgrade in SQL2008 R2

  We did an inplace upgradeof Production database from sql server 2005 to SQL 2008 R2 with same conf…

  Deviprasad

  7 replies

  13 years, 10 months ago

  By: David Webb-CDS

• create procedure on top of another procedure

  hello all, i am very new to SQL Server and i am trying to create a store procedure. I already hav…

  crazylifescary

  9 replies

  13 years, 10 months ago

  By: crazylifescary

• cached execution plan ?

  So if i'm in enterprise manager sql server 2008 and i have a stored proc call. for example exec get…

  BaldingLoopMan

  6 replies

  13 years, 10 months ago

  By: Gail Shaw

• Convert Text to Date DataType

  Hello Everyone, I have an sql table which stores dates from some other system as text. Eg.: …

  santa326

  15 replies

  13 years, 10 months ago

  By: Eugene Elutin

• Annoying join problem & frozen brain.

  create table A (a int, b int) create table D (a int) insert into A values (1,1) insert into A value…

  snomadj

  7 replies

  13 years, 10 months ago

  By: ChrisM@Work

• comma separate value show as table

  I have One table tbaleOne Column1 ------------------------- AA,BB,CC DD,EE,FF GG,HH,II I need out p…

  vishnu 9013

  16 replies

  13 years, 10 months ago

  By: Dwain Camps

• unbalanced [] in sqlserver identifier

  Is this a SQL Server 2008 bug? It parses fine. Note that the [] are unbalanced. CREATE TABLE [dbo].…

  ben cohen

  2 replies

  13 years, 10 months ago

  By: Sean Lange

• need help replacing cursor logic in stored procedure w/faster sql statement

  I've inherited some very slow code in a stored procedure that uses cursor logic to read a table of …

  Dave C.

  7 replies

  13 years, 10 months ago

  By: Dave C.

• Convert UTC string to DateTime

  Hi folks, I have one table and one of its column contains the data in this format. Thu Jun 14 15:07…

  Krishnraj

  2 replies

  13 years, 10 months ago

  By: Krishnraj

• FOR XML EXPLICIT add attribute to element

  I am coding procedures which extract XML that is returned to a client application. The following co…

  david.rowland

  1 replies

  13 years, 10 months ago

  By: handkot