Sorry... I've just seen one too many users who ditch the solution before even trying it... Glad you're not one of them.

Glad to see I'm not completly clusless in that departement .

Select Len('some,commas,') - len(replace('some,commas,',',','')) as NumberOfCommas is large????????

Select OneField from dbo.Split('String', 'separator') is large?????

Should be simple with the right design >>

Select threadInfo from dbo.Table order by ThreadStartDate, MessageDateInput

... as we all should .

What's wrong with this??

Select Len('some,commas,') - len(replace('some,commas,',',','')) as NumberOfCommas

--use the datetime here.. assuming that you don't always change at the minute exactly

Declare @Types table (DateStart datetime not null, name varchar(25) not null, primary key clustered (DateStart, name))

Declare @Production...

I'll withdraw my wohh!!! then. Still was a funny 15 minutes .

Seems to me like you need more of a recursive algorithmn... Are you planning to load all the message in one shot anyways?

How do you call it when actors start using lines to be able to throw in a joke a few lines later???

Probabely 2 things make this a low rating >>

1 - Formatting should always be done at the client if possible

2 - This doesn't need a function to be accomplished,...

I'm not the security expert here... I'll let someone else pick this one up.

First off... why are you using dynamic sql for this??

count >>

Select Len('some,commas,') - len(replace('some,commas,',',','')) as NumberOfCommas

Maybe this split function can be of some use :

IF Object_id('fnSplit_Set') > 0

DROP FUNCTION dbo.fnSplit_Set

GO

IF Object_id('Numbers') > 0

DROP TABLE dbo.Numbers

GO

CREATE TABLE dbo.Numbers (PkNumber...

This is a foramtting task.. Do that with the app, not the server.