sql server data mining: Query retreiving dfferent results on same data -- sql server data mining

Query retreiving dfferent results on same data

Ashish Nanda
8/9/2004 5:19:50 PM

sql server data mining: Hi i am running a query where i am creating intermediate
tables andthen doing a distinct select from these tables.
For some reason the result obtained from this is different
i run it the first few times and then finaly it stops and
gives me same numer of rows. Does it have to do SQL Server
or is there anything else?
Can someone think of something why is this happening.

Re: Query retreiving dfferent results on same data

Adam Machanic
8/10/2004 9:34:27 AM

Ashish,

It sounds as if some other connection is modifying the table while you're
querying it. Run a Profiler trace to find out what else is going on.

[quoted text, click to view]