It's not very clear to me.

Try posting some sample data and the desired output.

You could also try reading the article linked in my signature line, it will help you rephrasing...

I haven't seen any matches yet, but tonight they're playing Italy vs. Paraguay.

Vuvuzelas will get soon into my sleep.

Lynn Pettis (6/11/2010)

---

Anybody out there know much about this individual, scott.pletcher?

I know we have several MVP's here on SSC, but most of you don't advertise it, and perhaps its just...

I see you decided not to take my advice.

Object and column names are part of...

Scott, you simply don't know what you're saying. If you have some arguments, go on, but I suggest you...

Nice article, Jason.

I haven't tried your code yet, but looks very neat.

Well done.

Can anyone take a look at this one?

I'm sure my solution sucks and I'm pretty sure the OP is lost and clueless.

OK, let's try to...

OK, basically it's the same thing. I don't remember the exact syntax and I don't have SSMS here, but you will have to rebuild the clustered index into a new...

Steve Jones - Editor (6/5/2010)

---

In a source control session at SQL Saturday #22. Surprising that quite a few people don't use an VSC for their SQL Code.

What do you guys...

In my organization we have SAs and one DBA (me).

SAs configure and maintain the OS layer, including patches, and I maintain the SQL layer.

I'm in the Administrators group for the...

Another assumption: 🙂

CREATE FUNCTION fSplitNumeric(@parameter nvarchar(4000))

RETURNS TABLE

AS

RETURN (

WITH Data AS (

SELECT N,

S = SUBSTRING(@Parameter,N,1),

G = CASE WHEN SUBSTRING(@Parameter,N,1) LIKE '[0-9]' THEN 1 ELSE 0 END

FROM Tally

WHERE...

You could change the query in the dataset to retrieve the denominator as:

ISNULL(NULLIF(SUM(someField),0),1)

So, you mean splitting a SINGLE char field upon a delimiter?

There's a good split function...

You mean partitioning?