I think you should do that application side. But for the fun of it :

Start with a derived table that has the rownumber and groupid in it. ...

Easier to find once you know what you're looking for .

... and for the record, this isn't a stored proc .

Must be that... that's undocummented in my bols .

No offense, but we posted the same solution???

dbcc inputbuffer (spid) ??

Now that I rethink of it. I would do it with a table variable. I'd get the first few columns into the table variable, then join to itself...

Even with 2 strigns of 8K, the execution is still in the ms for my split function... No problems there.

CREATE TRIGGER [AfterInsertOrderLine] ON [dbo].[OrderLine]

AFTER INSERT

AS

SET NOCOUNT ON

UPDATE O SET TransType = 'xyz' from dbo.OrderLine O inner join Inserted I on O.OrderLine = I.OrderLine

My rule of thumb is this.

If the field is calculated, accessed often but with a value that never/rarely changes, you can keep it in the db. The best exemple...

Just do the select like if you wanted to always get that phone number. Then write this :

CASE when accountlevel = 10 THEN AdminInfo.PhoneNumber ELSE 'Another field, or...

Depends on the situation and how you store it. What is your need at this point?

Hey jesper.. delete your first post... or edit the table tags.

So you need to count the number of time the items are in both the ITEM_COMP and products table, but only if they are in the ITEM_COMP table?

How are you calling that sp??

What's the sp code?