Posts by Joao Araujo • 46 points

• 2

  votes

  2

  answers

  100

  views

  A: Dynamic TSQL for multiple returns

  The way to use parameters with sp_executeSQL() is really not very intuitive, it is better to even read the microsoft page itself on the subject: sp_executesql (Transact-SQL) Here is the solution:…

  sql sql-server tsql

  answered 9 years, 2 months ago Joao Araujo 46

• 1

  votes

  1

  answer

  271

  views

  A: Remove fixed-sized part of an xml

  This error means the function SUBSTRING is receiving a negative value in the parameter start or in the parameter length. If the desired value appears always between tags <vMerc></vMerc>…

  sql sql-server xml

  answered 9 years, 2 months ago Joao Araujo 46