In one of my stored procedures, I have two t-sql statements. The first is an

update command and the second is a select. When I take out the update, the

select returns a recordset just fine. When I leave in the update, select

doesn't work. However, update still works.

I even SET NOCOUNT ON, also.



Can anyone tell me what I am doing wrong?



Moe

Stored Procedure Source code please.