And another solution using nested REPLACE.

WITH PartialNames AS (

SELECT * FROM (VALUES('first,,'),('first,,last'),(',middle,last')) d (PartialName)

)

SELECT REPLACE( REPLACE( RTRIM( LTRIM( REPLACE( PartialName, ',', ' '))), ' ', ','), ',,', ',')

FROM PartialNames

This might be more work for the engine but I was having some fun with the DelimitedSplit8k splitter.

WITH PartialNames AS (

SELECT * FROM (VALUES('first,,'),('first,,last'),(',middle,last')) d (PartialName)

)

SELECT

STUFF((SELECT ',' + item...

serg-52 (4/22/2015)

---

Thank you, Luis....

Put the COUNT outside the CASE.

Your function is missing the ORDER BY at the end. It might seem to return the correct results but it might fail at any time.

Just wanted to note that in SQL Server 2008 there's the DATE data type which won't include time. For hire dates it seems a better option.

Check the different Date and...

This can be done with a recursive CTE. You can find many examples on the internet.

It should be something like this:

WITH RCTE AS(

select T1.a1, T1.a2, T1.a3,

T2.b1,...

This is a possibility using the Quirky Update.

CREATE TABLE #TEMP (ID int PRIMARY KEY, DateCreated datetime, IsDoubleLag bit)

INSERT INTO #TEMP VALUES (1,'2015-01-01 08:11:40.490','0')

INSERT INTO #TEMP VALUES (2,'2015-01-04 02:29:47.777','1')

INSERT INTO #TEMP...

This is another option.

WITH Conditions AS(

SELECT ORGN, BDOB, TM_PERD

FROM (VALUES('A1', 'B1', 'C1'),

...

CAST is very simple :-). You'll have more...

Would you be comfortable using the Quirky Update? http://www.sqlservercentral.com/articles/T-SQL/68467/

I know, but...

The magic is in the REPLACE() which will implicitly convert the number into a string when it receives the data. Other string functions such as LEFT(), RIGHT(), LEN() and others...

sql-lover (4/14/2015)

---

Hmmm .... thinking loud and to myself.

I still would like to hear any advice but I think I can't rollback DDL statements in TSQL. In other words, and after...

You'll need a FULL OUTER JOIN which...