T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Avoiding IF/ELSE

  --I believe the DDL and my commented out notes and questions should explain what I am hoping to ach…

  Chrissy321

  13 replies

  13 years, 5 months ago

  By: Eugene Elutin

• Updation

  I have a table proceduremaster in which I need to update ParentProcedureID on basis of procedurecod…

  kapil_kk

  14 replies

  13 years, 5 months ago

  By: Jason-299789

• Need an Efficient Way to Rank Rows with Some Rows Having the Same Rank

  Does anyone have a suggeston on the most efficient way to do this ranking? I need to add an increm…

  Hari Seldon-821789

  8 replies

  13 years, 5 months ago

  By: The Dixie Flatline

• xml data type vs several records

  Hello I am trying to save student answers to questions in a quiz I am looking for best performance …

  Sarsoura

  3 replies

  13 years, 5 months ago

  By: Jeff Moden

• TSQL Split XML attributes

  I have an xml string and need to manipulate it within sql. <RuleData ReturnVariable=""> &l…

  pricejt

  2 replies

  13 years, 5 months ago

  By: Eugene Elutin

• Get Records according to dataset.

  Hello Expert ! I have a CTE Query but I have nothing concepts about it. And I am new in programming…

  abdul_rouf26

  5 replies

  13 years, 5 months ago

  By: Jason-299789

• Full Database Backup with no truncate

  Hello! I need write tsql statement for full database backup without truncate log Please Help

  alex_zilberman

  6 replies

  13 years, 5 months ago

  By: Gail Shaw

• Identity column reseed cause problem with other database

  We have a data warehouse team that uses the identity column (surrogate key) as primary keys for man…

  sqlfriend

  8 replies

  13 years, 5 months ago

  By: sqlfriend

• table valued function

  I have a table (inherted from some else) QuestionID, Layout (Ex.{1,4,3,2} Answers (ex.'First answer…

  Sarsoura

  5 replies

  13 years, 5 months ago

  By: Gail Shaw

• Update one table rows with another table if match found

  Hi, I'm having 2 tables, One table holds some numbers of type varchar and the other table holds the…

  User7766

  5 replies

  13 years, 5 months ago

  By: User7766

• Accurate Computation of Age

  Simple way to compute your age accurately. A lot of query not exactly compute the age? yes! because…

  math martinez

  5 replies

  13 years, 5 months ago

  By: Michael Valentine Jones

• Local variable and Try/Catch conundrum

  Hello All, I understand that the scope of a local variable/table variable declared inside a TRY blo…

  ColdCoffee

  1 replies

  13 years, 5 months ago

  By: ScottPletcher

• Read TRN Data

  Hi Gurus, We've configured MS SQL Server 2008 R2 and restored the recent backup of PRD database (.b…

  Peter2012

  1 replies

  13 years, 5 months ago

  By: KylesWay

• duplicate rows

  hi my table has following data productno productname des quantity 1 …

  harri.reddy

  2 replies

  13 years, 5 months ago

  By: MMartin1

• Need to tune this query

  HI All, COuld you please help me to tune the below query.. Thanks in advance.. -- SET NOCOUNT ON a…

  moosamca

  1 replies

  13 years, 5 months ago

  By: GSquared