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

...

On the contrary, it is very useful as it respects the left outer join, which in essence return all records from the right hand side and only those on the...

Think of it this way, the AND will satisfy all records on the right hand side and return NULL on the left hand side for those records not satisfying the...

Quick suggestion, change this to a merge statement, look into the merge match conditionals "when matched" straight forward to handle this that way.

😎

Of course the more information provided the better the answer/advice;-)

The tables can of course be created beforehand, the solution posted is one of many ways of doing this. Tell...

Quick thought, conditioning a left outer join query on a column on the left side of the join effectively turns the join into an inner join, when the same predicates...

Good input @Seong-Bae Hwang, your approach is much more efficient as it bypasses the expensive XML table value functions and the string manipulation. Well done!

Must admit that I got a...

The task of populating a table from a stored procedure is simple, isolating the data for each client which makes this slightly more complicated as preferably each client should have...

Google doesn't like nnnnn..nnnnnn, try searching any set of numbers and the G guy will tell you he's sorry. Probably an effort to stop certain type of searches like ip...