T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• What is RBAR? How can I avoid it?

  Hi, I'm new to t-sql and I do not know much regarding how to write efficient queries. I read an ar…

  bjesmith2

  22 replies

  8 years, 4 months ago

  By: Jeff Moden

• Split Row into Multiple Rows

  Hi, I'm trying to split a row of data based around the quantity in the row. For example, if there …

  kate-395233

  15 replies

  8 years, 4 months ago

  By: Y.B.

• IF NULL then Zero (0)

  Hi, Using the sample data below, How would I convert Null to zero (0) if the count is NULL with out…

  EjSQLme

  6 replies

  8 years, 5 months ago

  By: Luis Cazares

• Performance issue with xquery

  Hi All, While investigating for performance issue in one of the query ,i found maximum execution co…

  sam 55243

  8 replies

  8 years, 5 months ago

  By: Igor Micev

• Number of weeks between two dates

  .

  Rem70Rem

  18 replies

  8 years, 6 months ago

  By: Jeff Moden

• TSQL RegEx find and replace without CLR

  Hi, I am having a table with a column which is having data like # followed by some number for Eg. #…

  Shaun-884394

  13 replies

  8 years, 6 months ago

  By: StanVanDam

• Records per hour within a time span

  Hello, I'm trying to come up with a way to count how many records exist on a hourly basis within a …

  daveb-840383

  27 replies

  8 years, 7 months ago

  By: amehul99

• I need to import xml to temp table but the tag is dynamic. How can I do it?

  I have 2 XML structure: 1) case 1 <nfeProc xmlns="http://www.portal.br/nfe" versao="2.10"> …

  lucyoura 86267

  2 replies

  8 years, 7 months ago

  By: lucyoura 86267

• Try/Catch RaisError Question

  I am doing something simple using Try/Catch Blocks that I need to confirm. If I execute a RaisError…

  meichner

  4 replies

  8 years, 7 months ago

  By: chinn.re1

• Management Studio Undoing My SQL Layout in Views

  Dear all, I'm sure many of you who have written queries with subqueries have taken the time to lay …

  robert.levy

  7 replies

  8 years, 7 months ago

  By: bwperrin

• Easy way to search for a string any where within XML column?

  Is there a really easy way to search for a string in an XML column? All the examples I come across …

  peterzeke

  25 replies

  8 years, 7 months ago

  By: below86

• Dynamic Ordinal Position with SQL XML?

  Hey all! I have a SQL XML GURU question. I have an XML that I essentially need to walk to get the…

  RyanNinness

  9 replies

  8 years, 8 months ago

  By: sandeepbandi1919

• Parsing multiple key-value pair columns at once

  Hi, I have a table where the data has been loaded in this format (I know it should have been parsed…

  chintan.floydian

  1 replies

  8 years, 9 months ago

  By: Mark Cowne

• getutcdate during daylight savings time

  Our nationwide call center needs to determine if they are making a call between 8 a.m. and 8 p.m. i…

  Marcia Q

  15 replies

  8 years, 9 months ago

  By: MMartin1

• TRY - CATCH with multiple errors

  If I open a new window in SSMS, attempt to backup a database, and the operation fails, I get two er…

  Dave Mason

  10 replies

  8 years, 9 months ago

  By: Dave Mason