Late to the party but how 'bout something like this?

DECLARE @Extract VARCHAR(3) = 'No'

,@desc VARCHAR(10) = 'TEST';

SELECT a.txt

FROM #test a

JOIN #test1 b ON a.id = b.id...

Thanks! I like to think of PatternSplitCM as sort of a...

Pardon my aging eyes. The link is there I...

Actually, this might be a little more straightforward.

WITH Sales AS

(

SELECT *, category=CASE WHEN period BETWEEN 4 AND 9 THEN 'Summer' ELSE 'Winter' END

...

Taking Jack's setup data and @d variable, I propose this.

WITH Sales AS

(

SELECT *, category=CASE WHEN period BETWEEN 4 AND 9 THEN 0 ELSE 1 END

...

Thanks for the set up data Jason.

I believe you can also do something like this:

CREATE TABLE #sometab

(

someid INT IDENTITY(1,1)

...

The Dixie Flatline (3/4/2014)

---

You're right about the issue with NULL strings, Dwain. The following change should take care of it.

with tally as (select top(ISNULL(len(@pstring),0)) N from dbo.tally order by...

I can do it with just two date function calls:

SELECT DATEADD(dd,DATEDIFF(dd,0,GETDATE())-1,'18:00')

I can also name that tune in 3...

Great article Jason! An enjoyable and informative read.

One question. In the section where you're describing left-deep/right-deep, is it safe to assume you're saying that the context only applies...

pandeharsh (3/3/2014)

---

oh sorry .i should have tested myself in machine before posting .

Actually ,

confused me.Now its clear .I thought this will directly insert into...

Evil Kraig F (3/4/2014)

---

Hey Dwain,

Excellent usage explanation article, thanks for that.

The issue with table parameters is the big reason you'd want to use one, cross database or cross server data...

The Dixie Flatline (3/4/2014)

---

I'm with Dwain on this one.

CREATE FUNCTION dbo.CleanString_bh

(@pString VARCHAR(8000),@pPattern VARCHAR(100))

RETURNS TABLE

AS

RETURN

(

with tally as (select top(len(@pstring)) N from...

Jason is a man of few words and a code-talker to boot! 😛

eg61088 - Good input and thanks for reading.

I'm not sure why you're drawing this conclusion from the article...