Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Transact-SQL (2005)  possible data isolation problem

Author  Topic  wongx2 Starting Member 1 Post Posted - 2010-11-16 : 19:30:09 I have a stored procedure, which is wrapped by a PHP which returns the resultset to the client as XML. In other words this is an XML REST service, written in PHP, and where the SP is the data provider. Near the end of the SP, I have a select statement that returns resultset data to the PHP. Right below that, there is 3 DELETE statements, which deletes that specific sessions data. Since this is all in one SP, do I need to do some kind of transaction or isolation between the SELECT statement and the DELETE statements in order to insure that the SELECT statement is accurately returning the recordset? Something like a GO statement between them, or putting the SELECT statement in a trans block (or vice versa around the DELETE statements)? Since this service is called by a FLEX UI, we're seeing inconsistent data sets, and I want to rule out that its not a data isolation