SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• t-sql 2012 match 2 strings

  In a sql server 2012 database, I want to find all the records where the lastname is not at least 'p…

  wendy elizabeth

  3 replies

  6 years, 9 months ago

  By: pietlinden

• VARCHAR(200) vs VARCHAR(2000)

  Hi All, Is there any performance difference between VARCHAR(200) and VARCHAR(2000), if inp…

  T.Ashish

  12 replies

  6 years, 9 months ago

  By: RonKyle

• Can you help me on this?

  1) In my table i have two columns i.e Name and marks,if i do aggregation on those two tables... wha…

  Krishh

  2 replies

  6 years, 9 months ago

  By: Steve Jones - SSC Editor

• Trining to get the first Id and Last anme

  Hi,I have a table with rows of data as follows:R_Index Customer ID First Name   Last…

  itmasterw 60042

  8 replies

  6 years, 9 months ago

  By: itmasterw 60042

• Find the root cause of SQL Server slowness and possibly killing blockers automatically

  Hi, we have noticed this morning around 9:30 AM EST that our applications became unresponsive. we s…

  Sridhar-137443

  8 replies

  6 years, 10 months ago

  By: Chris Harshman

• Help Using CASE instead of IF/. ELSE

  I have a user interface where the user is selecting a location code form a list of 25 location, we …

  Hogie503

  4 replies

  6 years, 10 months ago

  By: Hogie503

• delete records in batches‌‌ and recursive for tables

  I have number of tables , I want to purge record based 3 month timeline. eg: select * from sys.tabl…

  s.ravisankar

  10 replies

  6 years, 10 months ago

  By: Jeff Moden

• COALESCE Issues when controlling logic in a tvf

  I've been trying to improve the performance of a rather sluggish stored procedure, which has a fair…

  BrainDonor

  4 replies

  6 years, 10 months ago

  By: ChrisM@Work

• How can I combine the three queries to one and possibly improve performance

  I wish I can get help from this forum, any suggestion is appreciated. I have a project with some ex…

  PasLe Choix

  21 replies

  6 years, 10 months ago

  By: ScottPletcher

• Simple Pivot I think

  I have a data set that looks like this. Type Col1 Col2 Col3 Col4 Col5 Col6 Row1 10 10 10 10…

  Gary Wheeler

  3 replies

  6 years, 10 months ago

  By: Gary Wheeler

• SQL Name Search Help.

  Ex: Table 1 Contains Full name and below is example of dataFull_NameRobert D MasterJohn Cic MDRavi,…

  koti.raavi

  1 replies

  6 years, 10 months ago

  By: Gary Wheeler

• Msg 512, Level 16, State 1, Procedure Rpt_RSQC_MRRFormSSRSSp, Line 261 Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, , >= or when the subquery is used as an expression.

  I am executing a SP and am getting this error: Msg 512, Level 16, State 1, Procedure Rpt_RSQC_MRRFo…

  joshua.aldridge

  3 replies

  6 years, 10 months ago

  By: Lynn Pettis

• Change dot separated value to a comma separated value

  Hello, I need to insert value to a sql server table which is then the source for excel workshe…

  lukaszpiech

  2 replies

  6 years, 10 months ago

  By: lukaszpiech

• Need some help with some "XML Hell" please.

  I'm working on an expansion of an incredible idea by Fabiano Amorimthat (https://blogfabiano.com/20…

  Jeff Moden

  34 replies

  6 years, 10 months ago

  By: Ed Wagner

• How to split comma separated values stored in XML node and display as individual records Without using function- SQL Server 2012

  I have a requirement to split a csv data inside an xml node column and display as individual record…

  Patchai001

  4 replies

  6 years, 10 months ago

  By: Alan Burstein