Sorry, but that did not fix it. 

I was planning on making the Course_Level a selection from the data rather than a "hardcode"...  Hence, my idea of flexibility.  May not...

I was trying an approach that I hoped would be more flexible since I am assuming this is test data.  I ran into an odd problem I cannot figure out. ...

I have no idea what you are saying, but I REALLY like how you put it!!!

I must have worked at those places as well!!! 

I think it was supposed to be where the dates where not equal.  That is why I questioned the two tables not having shared EID's. 

That's an especially good solution if you are not starting from one and ending at a specific number. 

The other side, (I have not seen Remi for a while) you...

First off, you are not showing an EID of 4 in TableB for your join. 

Try this:

DECLARE @TableA TABLE( EID integer, [Date] smalldatetime, Remark varchar(10) NULL)

INSERT INTO @TableA...

DECLARE @Numbers TABLE( [Number] integer)

INSERT INTO @Numbers

SELECT 1 UNION ALL

SELECT 2 UNION ALL

SELECT 3 UNION ALL

SELECT 4 UNION ALL

SELECT 5 UNION ALL

SELECT 6...

Yip! Major downside if Timeout is an issue.  But might be a good test to see if the dates are having trouble... 

You may want to try: CONVERT( varchar(10), LQ.Date_IN, 101) BETWEEN @DateFr AND @DateTo 

Instead of: LQ.Date_IN BETWEEN @DateFr AND @DateTo 

I've not used XML in an SP, so I do not know what this is doing: 

SELECT '<XMLData>

<Decisions>

    <Decision char="N" desc="Not Verified" />

    <Decision char="R" desc="Rejected" />

    <Decision char="V" desc="Verified"...

This will not necessarily help performance, but try the ROUND function.  Look it up in BOL and you will see how the third parameter can be used... 

We too have...

I think you have a bit of a problem recognizing that you MUST have a WHERE clause in an UPDATE, else you update an entire table.  What you are doing in...

A quick fix might be to see where your "Value" match may be slowing down.  I would suggest using alzdba's query and commenting out sections to see where the slow...

I would like to keep this alive for a bit longer as I have replaced yet another cursor in the same fashion that Eddie Wuerch suggested, but I still get...