I agree with the latter two posts as well.

It also looks like your Error message is being raised from Usp_MessageBoard_InsertReply

However the proc you posted for us is [usp_MessageBoard_InsertMessage].

Please could you...

The Max lengh for a VARCHAR in 2000 is VARCHAR(8000)

Could you show us the table definition of the Messages table in your proc please

Also is the error in SQL or...

Could you show us your code PLEASE...

could you post some code please

I'm not 100% that that code is indicating what we thinking.

I tested it on my table:

where RowNum = SomeInt -- 1678

where 1 = 1 -- 5

where RowNum = RowNum --...

The reason I ask the above and I guess it's related to the OP.

for me with a table of 1mil rows I get very much the same results for the...

nice one.

I've done some testing with clustered and non-clustered indexes and combinations of both and the results are the same.

I was also thinking this might be a target for a...

That is very very interesting I must say, I wonder if this happens everytime?

I totally see what you mean.

But you right we need some advice here, I'll try and get some data together and see if I can work it out from a...

This all sounds very very interesting, could you explain a bit more about what you mean by Shortcircut OR ?

I've also noticed that

@Param IN (0,Column2)

produced a different order of the...

I'd be very interested in seeing the execution plans if that is still possible.

I have done some testing on my demo table of a mill rows and the results are...

As Gail mentioned please supply more information

Ok you need to make some var changes.

You are using a CHar(20) which has a set lenght and SQL is struggling to convert that.

Have you tried changed @e_Ncas to a...

Hi Gail,

When you say that a Clustered index is included in every non-clustered index, what do you mean by this?

Do you have where I could read up about this and...

DECLARE @MyTable TABLE

(Id INT,

Team CHAR(1))

INSERT INTO @MyTable

SELECT 1, 'A' UNION ALL

SELECT 2, 'A' UNION ALL

SELECT 3, 'A' UNION ALL

SELECT 3, 'B'

SELECT

Id,MAX(Team)

FROM @MyTable

GROUP BY Id

Look at how the Group...