T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• CASE Statement in SELECT clause to convert into the where clause

  ??? MCSE SQL Server 2012\2014\2016

  lkennedy76

  4 replies

  13 years, 4 months ago

  By: math martinez

• Convert values of mulitiple rows into single column with no duplicate entries

  hi all, i went through the forum and found out a way of concatenating row values into column using …

  sayedkhalid99

  6 replies

  13 years, 4 months ago

  By: sayedkhalid99

• T-SQL Query Help

  Hi, I have a table that looks like the following: CREATE TABLE [dbo].[EmployeePerms]( [EmployeeGr…

  Mike Scalise

  3 replies

  13 years, 4 months ago

  By: Mike Scalise

• Convert field from YYYYMMDD format to MM/DD/YYYY ?

  Hello, I have a date filed in the YYYYMMDD format ,want to convert it into MM/DD/YYYY. I have tried…

  SQL SERVER ROOKIE

  11 replies

  13 years, 4 months ago

  By: Sean Lange

• Creating square box polygon from Geography/Geometry Point

  Hi, I have a set of world grid points (lat/long) values. For each point, I have a 'geography' poin…

  darrin.wilkinson.66

  1 replies

  13 years, 4 months ago

  By: mickyT

• 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