Peter,

Do you have an example of how to use your fine split function to find dates in a table of strings like the original OP posted?

What's the maximum number of roles?

Just curious... What does the DTS package do?

It sure would be nice if you shared what you did to solve it... this is a forum, you know?

Craig,

You mean you fixed your problem?  Would you mind posting the solution?  This is a forum, after all

Just curious... why names like "SP20" ... not exactly "self documenting"...

Wow, Michael... not sure what happened there.  I've seen that before (post gobbling others) but not when I've posted.  Didn't even show what I posted.  Matt might be right... might...

Something like this will work...

ALTER FUNCTION [dbo].[GetSpecialsInCase]
(
@TCaseId varchar(25)
)
RETURNS VARCHAR(2000)
AS
BEGIN
DECLARE @itemList VARCHAR(8000)
SELECT @itemList = IsNull(@itemlist + ', ' + char(13), space (0)) + d.SpecialsDesc
FROM
(--=== Derived table "d" finds correct distinct SpecialsDesc
SELECT...

I know... preaching to the choir but I have to say it... Putting a better server on the dev side may not help that problem...

Hey there, Jules... long time no see.

I think these folks are all steering you in the right direction... One instance and multiple databases would be my inclination, as well, for...

Heh... like anything else, it only sucks when you don't know how

As suggested a couple of times... First SUM the minutes and THEN convert the result for display using one of the many methods shown.... you cannot aggregate non-numeric data with...

Yes... easily done... but you need to learn what ">>" means from the CMD prompt (or xp_CmdShell).  Lookup "Using command redirection operators" in Windows help (under the Windows [Start] button...)

Nicely done (as usual), Michael.  Simple, straight forward, nasty fast...

Heh... I understand what the rules are trying to say and (actually) very much agree with them, but I'm thinking that those definitions could be seriously misconstrued by those trying...