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...

Quick question, could you describe the problem you are trying to solve?

😎

Quick addition of another key element (SRC_ID)

😎

USE tempdb;

GO

;WITH BASE_DATE(BD_ID,SRC_ID,BD_FLAG) AS

( SELECT BD_ID,SRC_ID,BD_FLAG FROM (VALUES

(1 ,1,'ABC' )

,(2 ,1,'123' )

...

Quick thought, use the stuff function

😎

USE tempdb;

GO

DECLARE @SAMPLE_SIZE INT = 123;

DECLARE @PADDING CHAR(3) = '000';

;WITH T(N) AS (SELECT N FROM (VALUES (NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL))...

Quick demonstration

😎

USE tempdb;

GO

CREATE PROCEDURE dbo.PROC_ONE

(

@PARAM ...

According to the better half, yes:-P

😎

Quick "skeleton" suggestion

😎

USE tempdb;

GO

;WITH BASE_DATE(BD_ID,BD_FLAG) AS

( SELECT * FROM (VALUES

(1,'ABC' )

,(2,'123' )

,(3,'DEF' )

,(4,'FOO'...

KoldCoffee (10/19/2014)

---

...I incremented the JOIN condition in Eirikur's LEFT JOIN example and found that the entire left table is returned, whether the JOIN condition is <1, <2, <3, <4

SELECT

...