Second that.

From your code, the main part is:

*****************

SELECT @PNo = min(PNo) FROM #PT

WHERE PDone...

It looks to me like the only reason you need some sort of cursor/loop is because your stored procedure is designed to work on one row at a time. ...

Glad to hear. Yea, we had 2 to tornadoes touchdown within about 45 mintues of here last night. That's Nebraska for you, flat land w/ no directional landmarks,...

OK, that makes sense, you're capturing the queries manually through Visual Studios. In that case, you'll have to do as previously suggested and first past it into a text...

We're all still speculating as to what we think the problem is.

Marcus, how are you capturing the queries from Reporting Services? Can you give us an example...

Bingo. That should do it.

Where are you reading the query in from?

It's hard to say without knowing a bit more. You'll need to post your code as well as the table DDL, sample data (in the form of inserts) and...

Well, there have been some good suggetions for you here. Care to give a little feedback on where you're at with this one?

I'm in Omaha.

And I'm just as guilty as anyone else with jumping in and posting an answer when there are some valid outstanding questions that the OP has not answered....

NE huh. Welcome to my stomping grounds. If after you drive in and out of the state, you have any questions about oh, say....corn. Let me know!!...

What exactly are you trying to do? Why do you want the SP to get the results this way?

With your SELECT INTO FROM statement, your stored procedure will get recompiled every time it runs. When you ran them, did you run the entire contents of the SP,...

Have you tried running these queries outside of a stored procedure and seeing what results they produce?

Thats kind of the direction that I was taking here. This is outside of SQL and has something to do with the application, codepage, etc (which is also outside...