Ed Wagner (10/21/2014)

---

Luis Cazares (10/21/2014)

---

Eirikur Eiriksson (10/21/2014)

---

Ed Wagner (10/21/2014)

---

Eirikur Eiriksson (10/21/2014)

---

Luis Cazares (10/21/2014)

---

Eirikur Eiriksson (10/21/2014)

---

spaghettidba (10/21/2014)

---

Ed Wagner (10/21/2014)

---

Parma, Venice...these cities are making me think of authentic Italian food. I...

Luis Cazares (10/21/2014)

---

Eirikur Eiriksson (10/21/2014)

---

Ed Wagner (10/21/2014)

---

Eirikur Eiriksson (10/21/2014)

---

Luis Cazares (10/21/2014)

---

Eirikur Eiriksson (10/21/2014)

---

spaghettidba (10/21/2014)

---

Ed Wagner (10/21/2014)

---

Parma, Venice...these cities are making me think of authentic Italian food. I cook and...

LutzM (10/21/2014)

---

spaghettidba (10/21/2014)

---

Ed Wagner (10/21/2014)

---

Parma, Venice...these cities are making me think of authentic Italian food. I cook and am a HUGE fan of real Italian, so now I'm hungry....

Ed Wagner (10/21/2014)

---

Eirikur Eiriksson (10/21/2014)

---

Luis Cazares (10/21/2014)

---

Eirikur Eiriksson (10/21/2014)

---

spaghettidba (10/21/2014)

---

Ed Wagner (10/21/2014)

---

Parma, Venice...these cities are making me think of authentic Italian food. I cook and am a HUGE fan...

Luis Cazares (10/21/2014)

---

Eirikur Eiriksson (10/21/2014)

---

spaghettidba (10/21/2014)

---

Ed Wagner (10/21/2014)

---

Parma, Venice...these cities are making me think of authentic Italian food. I cook and am a HUGE fan of real Italian, so...

spaghettidba (10/21/2014)

---

Ed Wagner (10/21/2014)

---

Parma, Venice...these cities are making me think of authentic Italian food. I cook and am a HUGE fan of real Italian, so now I'm hungry. ...

Quick thought, redirect the stderr to the output using 2>&1

😎

Phil Parkin (10/21/2014)

---

Eirikur Eiriksson (10/21/2014)

---

I strongly belief that dynamic SQL solutions should be avoided if possible, it normally doesn't take much of an additional complexity to render them useless or...

Jeff Moden (10/21/2014)

---

Eirikur Eiriksson (10/20/2014)

---

Some code refactoring on the previous set based solution to fulfil all the requirements, several orders of magnitude faster than string manipulation although it has not...

I strongly belief that dynamic SQL solutions should be avoided if possible, it normally doesn't take much of an additional complexity to render them useless or at least very hard...

Hi and welcome to forum. Quick note, you should post this question in the appropriate forum depending on your SQL Server version.

The answer is actually in the question, look up...

Good point Luis! It is also around 30% faster,

Quick comparison

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @INT_BUCKET INT = 0;

DECLARE @CHAR_BUCKET CHAR(7) = '';

DECLARE @TIMING_RESULTS TABLE

(

...

byanaman1 (10/20/2014)

---

I have SP that generates the output in XML format. The file is generated correctly with all tags. However, at the beginning of each file I see couple of...

Another important aspect is the use of SQL code modules as a means for code modularisation, nudging the SDLC more towards SOLID so to speak, something that is immensely beneficial...

Some code refactoring on the previous set based solution to fulfil all the requirements, several orders of magnitude faster than string manipulation although it has not been tested on very...