I have a database. It doesn't work. Please advise.

Thanks in advance.

P.S. Please don't ask for DDL and sample data as I've already said that it doesn't work.

Sonova

Like Jeff said, you want a lot of time and disk space to go over 5 in length. However, this problem is what CROSS JOINS in SQL do...

Really happy for you, Jack. 🙂

IIIIIIIIIIIII LIKE IT !!:w00t:

Semicolons.

Can't live with 'em....

... pass me the peanuts.

But when semicolons are required between statements as separators, it would just be so EASY to start each new statement with a semicolon. Besides, reading from left...

Lynn also refuses to put commas at the beginning of a list of values. 🙂

Given how SQL treats white space, a semicolon is more properly described as a separator,...

Eskandari,

Sorry but I don't speak C#. What is the desired result?

Are you just trying to identify the strings between "!" and "~" ??

If...

SQLRNNR (3/5/2014)

RBarryYoung (3/5/2014)

SQLRNNR (3/5/2014)

A LOT

What happened to your website?

I was trying to get a script from there a week or so ago and...

Welcome back, Barry. Good to see your smiling face again.

I just read that fourth article on splitting strings based on patterns: Good stuff.

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 N)

If @pstring is...

Don't know what to tell you, Jeff. On my development box it's neck and neck for a short string but the margin of victory for the inline table...

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 dbo.tally order by...