That's not for splitting, that's for concatenating and I actually never used it in production. I do use the split thought for list of ids to process.

Yup this code really deals more with reporting problems than basic sql operations.

Here's an exemple :

SP:

CREATE PROCEDURE [dbo].[GetFormsByADP] @FkADP as int

AS

SET NOCOUNT ON

SELECT TOP 100 PERCENT PkObjADP, ObjName

FROM dbo.ObjADPS

WHERE FkTypeObj = 1 AND FkADP = @FkADP

ORDER BY ObjName

SET NOCOUNT OFF

vb6 call...

It's less efficiant than a single select, but it still takes less ressources than updating a temp table for every occurance of every row and then reselecting the temp table.

HTH.

I don't want to push the pain any further, but if you don't have relations, the system is just behond repair.

Does this correct the error and gives the expected output?

Select b.*

from

(Select ID, MAX(CustomerId) maxID,MIN(CustomerId) minID, MIN(UserID) UserID FROM MyTable ) a

INNER JOIN MyTable b ON a.ID=b.ID

WHERE

1=Case

when maxID=minId and a.UserId=b.UserId then...

Glad you got it worked out... there's nothing out of the ordinary with the trace you sent me. Next time you see something wrong with the queries you can...

I'm sorry, I was under the impression you needed help, but since you don't wanna help yourself, I'm outta here.

The id of all the tables are nullable which means you don't even have a clustered index, also they should be identity (nobody starts that discussion again here please). ...

Glad I don't need those here...

The question is : why would you need that?????????????

Insert into dbo.NormalizedModel (Animal)

Select ElementText

from dbo.Split('YourStringHere', 'delimiter')

Select Name as AnimalName, count(*) as Total

from dbo.NormalizedModel

group by Name

I count 2 lines of code here.

Where is the data coming from?

Have you check at the presentation options of the datetime field in the forms?

yep... why????????